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 / ranjith
Select Max(Salary) from emp_database where Salary < (Select
Max(Salary) from emp_database)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
when you create a database how is it stored? : Sql server database administration
What is a data source or ds? : sql server analysis services, ssas
How are the unique and primary key constraints different?
What are the types of table?
Explain a differential backup?
How to download and install microsoft sql server management studio express?
What is a rownum?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
What is use of except clause?
When does a workload on SQL Azure get throttled?
How do I uninstall sql server 2014?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
Which database stores information about replication?
what is memory-optimized nonclustered indexes
Is null in sql server?