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 ordinary table in oracle?

1238

How to create a testing table in oracle?

1031

What is a trigger and what are its types in oracle?

1148

How index is implemented in oracle database?

1040

What is a read write transaction in oracle?

1128

How to count duplicated values in a column in oracle?

1100

What is an oracle?

1063

How to execute a stored procedure in oracle?

1143

What are privileges and grants?

1102

Why is oracle used?

978

How to declare a local variable?

1171

What is a sub query and what are the different types of subqueries?

1171

How to connect to the server with user account: sys?

1059

What do you mean by a database transaction & what all tcl statements are available in oracle?

1036

What is a user account in oracle?

1166