write query for fourth maximum salary from employee table
- 14 Answers
- 22045 Views
- Mind Tree, SP Software, I also Faced
- E-Mail Answers
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
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
How do you debug a procedure in sql server?
What is database architecture? : SQL Server Architecture
Can truncate be rolled back?
What do you know about normalization and de- normalization?
What is clustered primary key?
Mention the uses of stored procedures.
How to stop log file growing too big?
What part does database design plays a role in performance of an sql server-based application?
what are user defined datatypes and when you should go for them? : Sql server database administration
How to list all login names on the ms sql server?
Explain the properties of a relational table?
Do you know exporting and importing utility?
What are rows and columns?
What are extended events in sql server?
