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 is the difference between TRUNCATE and DROP?

1067

Explain the difference between HTTP and HTTPS in database?

976

What are the dmvs? : sql server database administration

1005

How retrieve field names from the table in SQL through JAVA code?

1834

How to replace null values in expressions using isnull()?

1052

Which are the olap features?

907

Explain security with sql azure?

186

What is store procedure?

1009

How to specify the collation for a character data type in ms sql server?

965

how you can get the list of largest tables in a database? : Sql server administration

988

Can foreign key be duplicate?

1002

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

983

What is unique key constraint?

989

Is truncate a dml command?

892

What are temporal tables in sql server 2016?

840