Interested to Buy Any Domain ? << Click Here >> for more details...
1..Write an sql query to find the employee name who is
having 2 phone numebr?
2.Write an sql query to the the second highest salary of
the employee?
- 4 Answers
- 10920 Views
- I also Faced
- E-Mail Answers
Answer Posted / s kumar
Q1:select Emp_name from Table-Name group by Emp_name having
count(Phone)=2
Hope it'll work out.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
When it is desirable to describe files Internally?
are there any useful c runtime apis that I can call from rpg iv?
How to write record if no field or the field are different in physical file in rpgle ?
what is data area and how it is used in rpg program ?
how do I declare a table or array in rpg iv?
what are the key words you must use when using a subfile?
How can we know running job is batch or interactive?
Set on command is used for closed all opened files , initialize var and release resource , return cmd is used for return to calling program but my req. Is dnt close opened files and resource must released while doing transactions , how can i do this...?
is this a rpg channel?
1. What is bound-by-call and bound-by-reference? 2. Where and why is *Nomain used? 3. What are the difficulties faced by programmers when using service programs? 4. Explain the different ways of parsing and compiling XML in iSeries.
How to declare the pull button in AS/400..
what is the difference between do while and do until?
Hi Viewers can any body explain me how to update and ahange the already existed data in physical file using subfile ? please explain me with the code if possible?
What is difference between bind by copy and bind by reference?
what do you mean by an input subfile, what are the keywords required?
