Interested to Buy Any Domain ? << Click Here >> for more details...
write query for fourth maximum salary from employee table
- 14 Answers
- 24301 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
What is system stored procedures?
When should you use an instead of trigger?
what is isolation level at dead lock?
Can an automatic recovery be initiated by a user?
What extended events?
Tell me about joins in database system and explain each in detail.
What are the differences between union, intersect, and minus operators?
What is transact-sql language?
Write a sql query to display the current date?
How do I find the default sql server instance?
How do you drop an index?
How to delete duplicate rows in sql server?
Why variables called the most powerful component of ssis?
Ms sql server index?
Explain user defined functions?
