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
- 51431 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / ravi kumar
SELECT MIN(sal) FROM Emp WHERE sal in
(SELECT TOP 2 DISTINCT sal from Emp ORDER BY DESC)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are rest-style architecture's?
What is dimension table? : sql server analysis services, ssas
What is difference between join and natural join?
SQL Server Architecture ?
Explain the rules for designing files and file groups in sql server?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
Why do we use functions?
define and explain the differences between clustered and non-clustered indexes.
Explain atomicity?
How efficient you are in oracle and SQL server?
What are translations and its use? : sql server analysis services, ssas
What is delete query?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
Detail about query optimizer?
Define clusters?
