write query for fourth maximum salary from employee table
- 14 Answers
- 22033 Views
- Mind Tree, SP Software, I also Faced
- E-Mail Answers
Answer Posted / icedrop
select top 1 salary from (select distinct top 4 Salary from tablename order by salary desc ) result order by salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is primary key and example?
What are the types of database schema? : sql server analysis services, ssas
We need to perform what steps in the following order to work with a cursor?
How is a full-text index updated?
What is sql server query analyzer?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
What are the basic functions for master, msdb, model, tempdb databases?
Can You Use Data Mining Models In Ssrs?
Difference between 2NF &3NF ?
What kind of problems occurs if we do not implement proper locking strategy?
What do you mean by stored techniques? How would we use it?
Define outer join?
What action plan is preferred if sql server is not responding?
What is acid db?
What is the recovery model?
