select top 1 salary from emp where (salary<(select max (salary) from em

how to find nth highest salary

Question Posted / smitam

Answer Posted / smitam

select top 1 salary from emp where (salary<(select max
(salary) from emp ))ORDER BY salary DESC

Is This Answer Correct ?

9 Yes

21 No

Please Help Members By Posting Answers For Below Questions

Why do we need normalization?

977

Can we add our custom code in ssis?

1040

Explain about the command-line tool SQLCMD?

1145

What are system databases into sql server (2005/2008)?

1049

What is function of ROLLUP ?

1140

If a table does not have a unique index, can a cursor be opened on it?

959

What to perform pattern match with the like operator?

934

Why I have to use stored procedures?

1096

Can we use trigger new in before insert?

963

According to you what goes into making the best database administrator? : sql server database administration

1023

List the data types available in mssql?

1104

What is the difference between DataRow.Delete() and DataRow.Remove()?

1273

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

1099

How can we delete a table in sql server?

1022

Does windows server 2016 come with sql server?

986