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 is Extended user-defined?

965

What is the function of inner join?

1076

Can a trigger be created on a view?

961

What happens if null values are involved in string operations?

997

Explain the cursor lock types?

1061

Can group functions be used in the order by clause in ms sql server?

1019

last function used in MS Access to convert sql what function will use in sql

2078

how to create “alternate row colour”?

147

What are the advantages of having an index on the sql server?

926

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1227

Is sql server free?

921

Explain datetime2 data type in sal server 2008?

919

How to check parameter value in stored procedure sql server?

980

How many types of stored procedures are there in sql server?

1020

What is the Difference Between Primary and Foreign Key?

1013