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
- 11125 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
What is ment by record level identifier?
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 program status data structure?
what is the use of sflnxtchg?
how do you use commitment control in rpg?
How Chain operation copies the record's data to the input buffer for the program?
How many program bind in one module....
Suppose we have one database file and it is used by 5 programs and in 3 program we have to add some records in datbase file s what is the impact on other program?
If my rpg program has a date field, what extra care I have to take while compiling that rpg program? If the file is keyed and I have declared the file as well as key list properly in my program. Still am getting an error message like "chain/reade operation is not allowed" what may be the case?
how do I declare a table or array in rpg iv?
what is a rpg?
How to call one program from another program in RPG? please help me with the code
Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg
How can we know running job is batch or interactive?
How can we override a file during runtime in rpg?
