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 is triggers and stored procedures?

887

What is the New in SQL server 2008?

916

What are the two authentication modes in sql server?

1055

What happens if an integer is too big for int date type?

919

Explain unique key in sql server?

952

explain the storage models of olap? : Sql server database administration

879

How to download and install microsoft sql server management studio express?

972

What are the authentication modes in sql server? How can it be changed?

1051

What is ms sql server index?

1022

What is 3nf normalization form?

1021

Define outer join in sql server joins?

889

What new changes are being made in SQL Server?

1096

What is equi join with example?

1008

What is 1nf normalization form?

978

Which is better statement or preparedstatement?

866