Interested to Buy Any Domain ? << Click Here >> for more details...
write query for fourth maximum salary from employee table
- 14 Answers
- 24501 Views
- Mind Tree, SP Software, I also Faced
- E-Mail Answers
Answer Posted / avanish kumar
if you have a table emp and you have to find fourth maximum
salary from emp table then you will have to write this
query.....
select top 1 sal from (select top 4 * from emp order by sal
desc) as sal order by sal
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
can an automatic recovery be initiated by a user? : Sql server administration
What is difference between clustered and non clustered index?
What is a full text index?
Why variables called the most powerful component of ssis?
Explain having clause?
where the connection string store in the database
How do we synchronize On-Premise SQL server with SQL Azure?
How to create function with parameter in sql server?
How do I open a .db file?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
How much is a sql server license?
What does asynchronous call backs means?
What is the standby server?
How does stuff differ from the replace function?
How is table type constraint applied to a table?
