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
Explain the various types of normalization.
What is ase database?
What is the advantage of varchar2 over char?
What is sharded database?
What are the advantages of normalizing a database.
Explain phantom deadlock?
Explain storage manager?
What are the advantages of views in a database?
can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance
What is the Difference Primary key and Unique Key
what are wrappers and build ups and what it's use?
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)
What is difference between clustered, non-clustered and unique index?
What is a database string?