write query for fourth maximum salary from employee table
Answer Posted / raman
select top 1(esal) from (select top 2(esal) from employee order by esal desc) employee order by esal asc
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is difference between rownum and rowid?
What is a view and what are its advantages?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is the difference between a function and a trigger?
What is the recursive stored procedure in sql server?
What are dml triggers and types of dml triggers?
What are the differences between char and varchar in ms sql server?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
Explain activity monitors
If the job running very slow what is the action you do
How to set a database state to offline in ms sql server?
State the difference between union and union all?
Mention the differences between having and where clause.
What is filestream?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration