select top 1 * from ( SELECT DISTINCT TOP 3 salary FROM tblemp ORDER BY

find the 3rd max salary

Question Posted / kk

Answer Posted / kk

select top 1 * from (
SELECT DISTINCT TOP 3 salary
FROM tblemp
ORDER BY salary desc) t order by salary asc

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are different types of raid configurations? : SQL Server Architecture

1086

What is use of except clause?

1092

How to maintain a fill factor in existing indexes?

1006

How will you hide an attribute? : sql server analysis services, ssas

958

How to trouble shoot if unable to connect SQL Server

1992

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1101

How to get a list of columns using the "sys.columns" view in ms sql server?

954

Explain Geography datatype in SQL Server

1131

How to find out the list schema name and table name for the database?

942

Explain different types of collation sensitivity?

982

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1142

How to set a database state to offline in ms sql server?

1046

What is b tree index?

915

Explain following error properties?

1019

What is entity data services?

1066