Query to get max and second max in oracle in one query ?
Answer Posted / deepa
select salary from (select salary from table_name order by salary desc) where rownum<3;
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Does facebook use oracle?
What is Java Pool in Oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How many types of tables supported by oracle?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
Explain the use of full option in exp command.
Respected sir, Please send me technical questions related to oracle apps..
What is flashback in Oracle?
What are the benefits of ordbms?
Explain the characteristics of oracle dba?
How to see the table columns used in an index?
Explain the use of log option in exp command.
How to connect to oracle using service name instead of sid?
why dont we assign not null constraint as table level constraint.
Give the different types of rollback segments.