select * from tablename.aliasname where nth=select count(sal) from tablena

how to find nth highest salary

Question Posted / udathayadav

Answer Posted / udathayadav

select * from tablename.aliasname where nth=select
count(sal) from tablename where aliasname.sal<=sal

Is This Answer Correct ?

38 Yes

26 No

Please Help Members By Posting Answers For Below Questions

How to use the inserted and deleted pseudo tables?

961

what are different types of raid configurations? : Sql server database administration

1055

What is collation sensitivity? Explain different types.

1008

Does sql server 2016 have ssms?

960

How to get the definition of a stored procedure back?

977

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

1014

What happens when transaction log is full?

925

What is shrink log file?

897

Why is replication required on the sql server?

1060

What is a result set object returned by odbc_exec()?

1028

What is the report model project?

141

What are sql dirty pages?

1021

What is the maximum size of column in sql server?

891

What is the correct order of the logical query processing phases?

936

What is 2nf in normalization?

997