write query for fourth maximum salary from employee table
Answer Posted / ajay roy
The Correct answer is ---
select salary from employee aa
where 4=(select count(*)from employee bb
where aa.salary<=bb.salary)
Thanks Elumalai.k
Top Keyword returns the top(first) row not the max record
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is default constraint?
What are three major types of constraints?
Explain triggers?
What is exporting and importing utility?
What is the difference between having clause and where clause in sql server?
Write an sql query for deleting duplicate rows?
What is optimization and its types?
how to use DTS package in 2000,2005,2008 in sql server
How do I view a stored procedure in sql server query?
Explain indexed views?
what stored procedure would you use to view lock information? : Sql server administration
What is the use of stored procedure?
How to find tables without indexes?
What is the difference between system objects and user objects?
Do you know how to store and query spatial data?