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
- 59386 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
Tell me what is de-normalization and what are some of the examples of it?
What should be the fill factor for indexes created on tables? : sql server database administration
What is transaction server distributed transaction?
How to create and drop temp table in sql server?
Explain “row_number()” in sql server with an example?
what is the difference between a primary key and a unique key? : Sql server database administration
Describe in brief authentication modes in sql server.
Why is sql server log file full?
what are the different stages of Report Processing?
What is use of except clause? How it differs from not in clause?
What is a periodical index?
What are different types of replication in sql server?
What is query optimizer in sql server?
How do you delete duplicate records in sql server?
Tell me when is the update_statistics command used?
