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

What are the different types of sql server replication? : sql server replication

1368

How to optimize stored procedure optimization?

966

What is recompile sql server?

1084

What is user-defined function?

1035

What are the requirements on sql server network connections?

1041

What is extent? Types of extents?

1276

How to use union to merge outputs from two queries together in ms sql server?

1136

Why and when do stored procedure recompile?

1029

How do you improve the performance of a SQL Azure Database?

137

Explain the Ways to improve the performance of a sql azure database?

What is a join in sql? What are the types of joins?

1190

what is the difference between count(*) and count(1) ?

1125

How to create indexed view?

1106

Define cursor locking

1061

How to drop an existing schema in ms sql server?

1145