with cte as ( select dense_rank() over (order by salary desc) maxSal ,*

How to find 6th highest salary from Employee table ?

Question Posted / vj

Answer Posted / vj

with cte as
(
select dense_rank() over (order by salary desc)
maxSal ,* from Employee )
select * from cte where maxSal=6

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to generate create table script on an existing table in ms sql server?

1115

What is meant by indexing files?

1006

How can you find out which stored procedures are recompiling?

898

Explain tables in SQL Azure?

120

What is xdr?

951

Can two tables have the same primary key?

1158

What the different components of Replication and what is their use?

1032

What are the source of constraints?

876

How to find the list of fixed hard drive and free space on server?

1128

What are Spatial data types in SQL Server 2008

983

What languages bi uses to achieve the goal?

972

Can we join two tables without primary key?

996

What is primary key index?

942

Do you know sql server 2008 backup compression?

939

What is the command used to check locks in microsoft sql server?

995