select salary from( select row_number() over(order by salary desc) as rno

How to find 6th highest salary from Employee table ?

Question Posted / lince thomas

Answer Posted / lince thomas

select salary from(
select row_number() over(order by salary desc) as rno,*
from Employee)T where T.rno=6

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the different editions available in sql server 2000?

1113

What are the aggregate and scalar functions?

1133

What are the new features of sql server 2012 reporting service?

141

What are 3 ways to get a count of the number of records in a table?

1122

How to delete exactly duplicate records from a table?

1110

What are the indexes in sql server?

1189

What is the temp table?

975

What is the difference between Normalization and De-normalization?

1145

What does dml stand for?

995

How can you know if the row fetched from cursor is still valid in underlying table?

1046

How much is a sql server license?

1011

How do you test your database? : sql server database administration

1071

How would you choose between a clustered and a non-clustered index?

1019

What is the contrast between sql and mysql?

1158

What is normalization? Describe its different types.

1154