Interested to Buy Any Domain ? << Click Here >> for more details...
write query for fourth maximum salary from employee table
- 14 Answers
- 24143 Views
- Mind Tree, SP Software, I also Faced
- E-Mail Answers
Answer Posted / yogendra barode
Select top 1 salary from (select top 4 salary from tbl_emp
order by salary desc) temp_tbl order by asc
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
What's the information that can be stored inside a bit column?
What are the advantages of stored procedure in sql server?
define and explain the differences between clustered and non-clustered indexes.
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
How to convert a unicode strings to non-unicode strings?
What are the approximate numeric data types?
Explain about remote stored procedure?
Can a table have 2 primary keys?
Explain transaction server distributed transaction?
What is command parameter in ssrs?
What is difference between group by and having?
Explain primary key in sql server?
Why I am getting this error when dropping a database in ms sql server?
Does partitioning help performance?
