SELECT SAL SECOND_MAX_SAL FROM (SELECT SAL,DENSE

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

Question Posted / satish

Answer Posted / satish

SELECT SAL SECOND_MAX_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

What is parameterized cursor in oracle?

1132

How to convert a date to char in oracle? Give one example.

1059

What is instant client oracle?

1017

How to create tables for odbc connection testing?

1103

What do you mean by merge in oracle and how can you merge two tables?

945

What is the use of file param in imp command?

1159

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

3049

How to connect the oracle server as sysdba?

1072

Why should I use oracle database?

983

How to write an inner join with the where clause in oracle?

1041

What is a private synonym?

1580

How to use "in out" parameter properly?

1043

How to change user password in oracle?

1021

What is Redo Log Buffer in Oracle?

1198

Explain the features of oracle?

1038