find out the third highest salary?
Answer Posted / akshita
select * from (select e.*,rownum r from (select distinct
sal from emp order by sal desc) e) where r = 3
Is This Answer Correct ? | 43 Yes | 16 No |
Post New Answer View All Answers
What is oracle rowcount?
What are the logical operations?
How to start your 10g xe server from command line?
Explain what are the uses of rollback segment?
Explain the use of grant option in exp command.
How to define a sub function?
Is truncate autocommit in oracle?
What is using clause and give example?
How to connect ms access to oracle servers?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
what is the dual table in oracle?
What do you mean by merge in oracle?
What is a directory object?
What is blob data type in oracle?
Explain an index?