SELECT LEVEL,MAX(SAL) FROM EMP WHERE LEVEL IN(2,3) CONNECT BY PRIOR SAL&

find out the second highest salary?

Question Posted / nagaraju

Answer Posted / nagaraju

SELECT LEVEL,MAX(SAL)
FROM EMP
WHERE LEVEL IN(2,3)
CONNECT BY PRIOR SAL>SAL
GROUP BY LEVEL;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to run create database statement?

979

What is the maximum limit on the number of columns in a table?

1012

What are nested tables?

1107

How to initialize variables with default values?

1164

What is PL/SQL ?

1908

What is oracle in java?

913

Respected sir, Please send me technical questions related to oracle apps..

1762

What do you mean by a deadlock?

1011

How do I reset a sequence in oracle?

1054

How to lock and unlock a user account in oracle?

1030

How to use regular expression in pattern match conditions in oracle?

977

What is parameterized cursor in oracle?

1069

What are the different pseudo commands? Explain in general?

1022

What is execute immediate in oracle?

952

How do I recompile a procedure in oracle?

912