SELECT TOP 1 salary FROM ( SELECT DISTINCT TOP 1 salary FROM table

how to find nth highest salary

Question Posted / sharmila shree

Answer Posted / sharmila shree

SELECT TOP 1 salary FROM
( SELECT DISTINCT TOP 1 salary FROM table_name
ORDER BY salary DESC )
a ORDER BY salary

here 'a' is sub query of salary

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to stop log file growing too big?

956

How do I edit a stored procedure in sql server?

883

What is difference between count (*) and count column?

841

How does stuff differ from the replace function?

960

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

965

How to defragment table indexes?

932

what is a correlated sub-query? : Sql server database administration

895

How do you rename a table in sql server?

940

Is it safe to delete log files?

870

What is the difference between ‘having’ clause and a ‘where’ clause?

993

What is difference between primary key and foreign key?

836

How is sql server used?

910

What is difference between rownum and row_number?

911

Explain different backup plans?

883

What is bulkcopy in sql?

903