Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
- 35 Answers
- 61252 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / sarat
TO FIND THE Nth HIGHEST SAL IN EMP TABLE
SELECT MIN (salary) as NthSalary FROM emptable WHERE
salary IN ( SELECT DISCINCT TOP N salary FROM emptable
ORDER BY salary DESC )
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
What is dirty page?
How to populate a table in sql server?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What is the difference between Stored Procedures and triggers?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
What is a constant or literal in ms sql server?
Please explain what is “asynchronous” communication in sql server service broker?
What are the database objects? : SQL Server Architecture
What is the largest component inside a field?
What do you understand by mirroring and mention the advantages of the mirroring?
Define tool Manage Statistics in SQL Server 2000 query ?
Do you know nested transaction?
What happens if an integer is too big for int date type?
What is transactional replication?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
