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 / prathapshankarshiva
select max(salary) from (select salary from table1 where
salary<(select max(salary) from table1))
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to use the inserted and deleted pseudo tables?
What is the bookmark lookup and rid lookup?
What is a file group?
What is the difference between Normalization and De-normalization?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
What is the difference between dataadapter and datareader?
How to sort query output in descending order in ms sql server?
How do I find the sql server instance name?
How to create an multi-statement table-valued function?
How do I completely remove sql server instance?
Explain tables in SQL Azure?
What is your recommendation for a query running very slow? : sql server database administration
What is service broker?
Is sql server is free?
Is it important for a database administrator to understand the operating system and file access?