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 oracle database client?

1037

What are the differences between blob and clob in oracle?

1090

What is oracle used for?

1029

How would you go about verifying the network name that the local_listener is currently using?

2050

Explain joins in oracle?

1041

What is a cursor in oracle?

1182

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

1129

What is oracle data type?

973

How to create a new tablespace in oracle?

991

Is postgres faster than oracle?

1046

How to view existing locks on the database?

1057

How do you bind variables in oracle?

985

What privilege is needed for a user to insert rows to tables in another schema?

1015

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1740

Why use resource manager in Oracle?

1110