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

How to use column default values in insert statements in ms sql server?

1104

Write down the syntax and an example for create, rename and delete index?

1028

What is store procedure?

1117

What is database architecture? : SQL Server Architecture

1101

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1874

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1116

How to create a dml trigger using create trigger statements?

1085

What is a coalesce function?

1254

What is the process of normalization?

1182

What is normalization process?

1241

What is server-level principal?

122

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

1101

What are the different types of locks in the database?

975

What does <> symbol mean?

1030

What is the name of the system variable that returns the number of rows affected by a SQL statement?

1070