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 / harsha
select * from my_table1 where sal not in (select max(sal)
from my_table1) order by Sal desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are window functions in sql server?
How do I start sql server agent automatically?
Does transparent data encryption provide encryption when transmitting data across the network?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
How do I perform an unattended install of sql server 2000?
what is a transaction? : Sql server database administration
What is the difference between clustered index and primary key?
How to create dbo table in sql server?
What is normalization according to you and explain its different levels?
What is equi join with example?
what are the core components of SSRS?
List out the differences between the clustered index and non-clustered index in sql server?
What do you understand by triggers and mention the different types of it?
Name three of the features managed by the surface area configuration tool? : sql server security
Explain the truncate command?