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
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 acid properties? : Sql server database administration
What is an example of a foreign key?
what is the maximum size of a row? : Sql server database administration
What is the difference between substr and charindex in the sql server?
What methods do you follow to protect from sql injection attack?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
How can I change procedure name in sql server?
What is subquery explain with example?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What is an indexing strategy?
What is the difference between Triggers and Stored Procedure?
What are the steps to insert a table?
What is database mirroring?
How to insert multiple rows with one insert statement in ms sql server?