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

Explain view?

1089

What is merge in oracle?

1098

What do database buffers contain?

1083

Which is better Oracle or MS SQL? Why?

5038

How to grant create session privilege to a user in oracle?

1055

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1066

What is the difference between sharding and partitioning?

1041

How to create a table interactively?

1167

How to define a specific record type?

1138

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

1037

What do you understand by a database object?

1107

Define oracle database

1099

What privilege is needed for a user to create tables in oracle?

994

What is a trace file and how is it created in oracle?

1147

How to change system global area (sga) in oracle?

1067