SELECT SAL FROM (SELECT SAL,DENSE_RANK() OVER(ORDER BY SAL DESC) RANK FROM

Query to get max and second max in oracle in one query ?

Question Posted / satish

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

Please Help Members By Posting Answers For Below Questions

why dont we assign not null constraint as table level constraint.

2797

How to define a specific record type?

1136

What is coalesce function?

1144

Can the query output be sorted by multiple columns in oracle?

1052

What is the use of file param in imp command?

1215

What is proxy method?

1021

How to create id with auto_increment on oracle?

1040

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3096

candidate key is subset of super key but not vice-verse explain

2106

Write a trigger example in oracle?

1113

How to test null values?

1154

Which environment variables are absolutely critical in order to run the OUI?

2172

How to update values on multiple rows in oracle?

1075

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1159

How to select some columns from a table in oracle?

1170