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 happens if you insert a duplicate key for the primary key column in ms sql server?
How do you run a trace?
Explain trigger and trigger types?
How to count rows with the count(*) function in ms sql server?
What is triggers and its types?
What is the current limitation of the size of SQL Azure DB?
How to download and install sql server 2005 books online?
Which trace flags are enabled in sql server?
What are the aggregate and scalar functions?
Where can you add custom error messages to sql server?
How to edit table in sql server 2017?
Explain transaction server auto commit?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
Why people hate cursor?