write a query for the fifth highest salary?
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
Is storing images in a database a good idea?
Differentiate between unique key and foreign key?
What is odm in database?
What is the difference between primary key, foreign key and candidate key?
What is difference between clustered, non-clustered and unique index?
Explain about ur projets on teradata???
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
What is ole db used for?
List some advantages of dbms.
What is a database example?
aht is the difference b/w network & hierarchial & relational dbms????
Explain alternate key?
What is the use of default key?
How do I manually create a database?
Explain the field term used in database.