find the 3rd max salary

Answer Posted / karthik

select min(salary) from (select top 3 * from employee order by salary desc) temp

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the Prerequisites for Replication?

10575


Explain the commands in sql server?

554


Is candidate a key?

537


How to delete all rows with truncate table statement in ms sql server?

494


How to delete duplicate rows?

557






Is the order of columns in the set clause important in ms sql server?

521


What happens if date-only values are provided as date and time literals?

547


What is normalization according to you and explain its different levels?

527


What is transact-sql language?

582


Can you explain full-text query in sql server?

554


What are rest-style architecture's?

149


How use inner join in sql server?

618


Are semicolons required at the end of sql statements in sql server 2005?

570


How to display a past time in days, hours and minutes?

577


How to connect to a sql server using odbc_connect()?

623