find the 3rd max salary

Answer Posted / neetu

Select Top 1 Salary from TableName where Salary IN(select
top 3 salary from TableName order by salary Desc) order by Asc

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of sql server replication? : sql server replication

630


Define primary key?

662


How to create an identity column?

644


What are various ways to enhance the ssrs report?

536


How to delete duplicate rows from table except one?

548






What is #temp and @table variable in SQL server?

590


What is the difference between dropping a database and taking a database offline?

702


whats new about truncate in sql server 2008?

2030


Can an entity have two primary keys?

533


Which tcl commands are available on the sql server?

607


What is rolap and its advantage? : sql server analysis services, ssas

649


What is named calculation? : sql server analysis services, ssas

536


What is the return type of executeupdate ()?

527


How to optimize stored procedures in sql server?

633


Which joins are sql server default?

514