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 the new features are introduced in sql server 2012 reporting services?
Explain Normalization and DE normalization
Determine how to use the inserted and deleted pseudo tables?
What is triggers and its types?
What is the partitioning method?
How do you run a trace?
Delete duplicate rows without using rowid.
How to execute a sql statement using odbc_exec()?
What is sqlcmd?
What is a schema in ms sql server 2005?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
How many replicas are maintained for each sql azure db?
What is the difference between TRUNCATE and DROP?
How to drop an existing stored procedure in ms sql server?
Does index slows down insert statements?