Select Top 1 (Salary) from emp where salary not in (select Top 3 (Salary)

write query for fourth maximum salary from employee table

Question Posted / pramod

Answer Posted / pramod

Select Top 1 (Salary) from emp where salary not in
(select Top 3 (Salary) from emp order by salary desc)
order by salary desc

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Is sql server difficult to learn?

867

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

941

List the types of recovery model available in sql server?

873

Can you explain important index characteristics?

941

How to make remote connection in database?

956

Why should we go for stored procedures? Why not direct queries?

1029

Explain indexed views?

928

If no size is defined while creating the database, what size will the database have?

931

What are commit and rollback in sql?

1053

how to determine the service pack currently installed on sql server? : Sql server database administration

909

What is ssl in sql server?

1013

How to create a new table in a given schema?

1114

What is merge replication?

1068

What are the benefits of normalization?

1045

Find nth lowest salary or get nth lowest salary?

966