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

What is ADDM Advisor in Oracle?

1175

Is rowid unique in oracle?

998

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1865

What are the original export and import utilities?

1170

How to create a stored procedure in oracle?

1103

Describe varray?

1058

Can you tell me how to add new column in existing views?how?How is possible?

1446

What are temporal data types in oracle?

1123

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2311

What are a query and state the different types of queries and their uses?

1015

What is a directory object?

1097

What is Library Cache in Oracle?

1142

What is an index associated with a constraint?

1040

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2355

What is a relational database management system?

1120