select * from(select salary,dense_rank() over(order by salary desc) as rno

How to find 6th highest salary from Employee table ?

Question Posted / lince

Answer Posted / lince

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

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is table valued function and scalar valued functions?

1050

What are the difficulties faced in cube development? : sql server analysis services, ssas

1018

Define Unique Key?

983

What is checkpoint in sql server?

1103

What is the difference between a view and a stored procedure?

1015

What happens if strings are casted into wrong code pages in ms sql server?

1098

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1971

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1043

What is the difference between for trigger and after trigger?

1084

Explain indexed views?

959

What is policy management?

977

List out the differences between the clustered index and non-clustered index in sql server?

987

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2192

How to provide values to stored procedure parameters in ms sql server?

1007

How can you hide the sql server instances?

1003