write a query for the fifth highest salary?
Answer Posted / chethan
select Salary from ( select salary from emp order by desc) as employee where rownum = 5;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the purpose of TNS?
What is a trace file?
how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
WHAT IS CARDINALITIES OF JOIN?
what is tkprof tool and how it is used???
What is a super key?
What is sharded database?
aht is the difference b/w network & hierarchial & relational dbms????
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
How do database connections work?
what is data access layer?
i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name
What do you mean by database?
Explain natural key?