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 is cached report?
How can we use ConnectorJ JDBC Driver with MS SQL?
What is the difference between sdf and mdf?
What are extended events in sql server?
In what sequence sql statement is processed?
Explain unique key in sql server?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
What is a print index?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What is difference between rownum and row_number?
Can coalesce return null?
What is tabulation?
List the different normalization forms?
What happens if null values are involved in boolean operations?
What is the difference between grant and with grant while giving permissions to the user?