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?
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
do you use message subfiles? What are the necessary keywords required coding a message subfile?
When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?
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 does the rpg element work?
what is a rpg?
what is an online rpg?
What is file identifier where we can use?
How many program bind in one module....
1.Load an runtime array of length 99 from the pf and you want to handle all the possible errors?
What is difference between bind by copy and bind by reference?
what is file information data structure?
Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
what is the necessary keyword needed to scroll subfile records?
What is ment by record level identifier?