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
- 10779 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 the use of sflnxtchg?
what is the difference between do while and do until?
How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...
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?
how do I preserve and clean the array?
what is the rpg system?
what is a rpg?
What is the purpose of record level identifier?
How to write record if no field or the field are different in physical file in rpgle ?
can you debug ile rpg program using isdb?
How to handle duplicate error handling in RPG?
What is ment by record level identifier?
Explain mdt?
can any one help in hawkeye and turnover or any change management system plzzzzz or send the documents to my mail id :gvsp.as4@gmail.com
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?
