Query to get max and second max in oracle in one query ?
Answer Posted / satish
SELECT SAL FROM (SELECT SAL,DENSE_RANK() OVER(ORDER BY SAL DESC) RANK FROM EMP) WHERE RANK=2;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
why dont we assign not null constraint as table level constraint.
How to define a specific record type?
What is coalesce function?
Can the query output be sorted by multiple columns in oracle?
What is the use of file param in imp command?
What is proxy method?
How to create id with auto_increment on oracle?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
candidate key is subset of super key but not vice-verse explain
Write a trigger example in oracle?
How to test null values?
Which environment variables are absolutely critical in order to run the OUI?
How to update values on multiple rows in oracle?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
How to select some columns from a table in oracle?