write a query for the fifth highest salary?
- 17 Answers
- 19665 Views
- IBM, Matlabs, Ramco, I also Faced
- E-Mail Answers
Answer Posted / skumar
Hi, friends This one is working fine. I have tested.
SELECT TOP 1 t.esal
from
(
select top 5 esal from employee order by esal desc
) t
order by t.esal asc
| Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
What is a super key?
What is ole db provider for sql server?
What do you mean by cluster and non cluster index?
When should you not use firebase?
issues involved in modeling and building data werahouses
What are the advantages of using database?
WHAT IS CARDINALITIES OF JOIN?
What is the Difference Primary key and Unique Key
What does currency type mean in database?
how do you do sql tuning?
What is Object Oriented model?
What is database and its types?
How many indexes can be created on a table?
Explain alternate key?
sparse lookup and where its options we find in OCI and db2?
