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,
modelyr_id_int
from
employee
) a
where
rnk = 4

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What do you think of this implementation? Can this be implemented better?

993

What is subquery in sql?

1125

How much memory that we are using in Logshipping Concept?

1842

role of sql sever 2005 in database rather than any other database

1986

What is oltp (online transaction processing)?

1057

What is a system database and what is a user database?

1138

What is explicit mode in sql server?

1109

What are the commands used in DCL?

1082

How to connect of datebase with sql express.?

1142

Can you use order by when defining a view?

1019

When should you use an instead of trigger?

1017

Why does sql studio use a single registered database repository? : sql server management studio

1036

Where actually sql azure database is hosted?

165

What is the difference between char and varchar2 datatype in sql?

1117

What is the difference between TRUNCATE and DROP?

1187