select distinct salary from ( select DENSE

write query for fourth maximum salary from employee table

Question Posted / anish tuladhar

Answer Posted / anish tuladhar

select
distinct salary
from
(
select
DENSE_RANK() over(order by salary desc) as rnk,
salary
from
employee
) a
where
rnk = 4

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain isolation levels that sql server supports?

1023

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2728

Explain what is the difference between union and union all?

990

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

1018

What is resource db in sql server?

1001

What is difference between getdate and sysdatetime in sql server 2008?

1040

State the difference between local and global temporary tables?

1094

What is a full text index?

912

Define tool Manage Statistics in SQL Server 2000 query ?

1063

what are different types of backups available in sql server? : Sql server database administration

918

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

951

What is nonclustered index with included columns ?

947

Tell me what do we need queues in sql service broker?

971

Define indexes?

1028

What is tablesample?

1088