Query to get max and second max in oracle in one query ?
Answer Posted / shareef
select ename,empno,sal,r from(select ename,empno,sal,dense_rank() over(order by sal desc) r from emp) where r=3; ----by using dense_rank()
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a table index?
Explain the use of file option in exp command.
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How to define an anonymous block?
What is the quickest way to export a table to a flat file?
How to rename an index?
How to check the oracle tns settings?
What is a private synonym?
How to define an oracle cursor variable?
Is postgres faster than oracle?
How do I uninstall oracle client from windows?
How to open and close an explicit cursor in oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How to start your 10g xe server from command line?
What are oracle functions?