write query for fourth maximum salary from employee table
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 |
Post New Answer View All Answers
Is sql server difficult to learn?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
List the types of recovery model available in sql server?
Can you explain important index characteristics?
How to make remote connection in database?
Why should we go for stored procedures? Why not direct queries?
Explain indexed views?
If no size is defined while creating the database, what size will the database have?
What are commit and rollback in sql?
how to determine the service pack currently installed on sql server? : Sql server database administration
What is ssl in sql server?
How to create a new table in a given schema?
What is merge replication?
What are the benefits of normalization?
Find nth lowest salary or get nth lowest salary?