write query for fourth maximum salary from employee table
- 14 Answers
- 22013 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
How do I start sql server?
Explain about thread and memory management process of SQL?
What does it mean to be in union?
explain declarative management framework (dmf) in sql server 2008?
what is the difference between openrowset and openquery?
How to insert data with null values?
What is built-in/administrator?
In what version of sql server were synonyms released?
What is delete query?
Does partitioning ssd reduce performance?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
Can foreign key be deleted?
Can sql servers link to other servers?
What are the differences between triggers and stored procedures?
How to get a list of columns in a view using the "sp_columns" stored procedure?
