SELECT DISTINCT(SAL) FROM EMP WHERE SAL=(SELECT MIN(SAL) FROM (SELECT SAL

how to find the second highest salary from emp table?

Question Posted / neeraj

Answer Posted / neeraj

SELECT DISTINCT(SAL) FROM EMP
WHERE SAL=(SELECT MIN(SAL) FROM (SELECT SAL FROM EMP ORDER
BY SAL DESC)
WHERE ROWNUM<=2);

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to rename a column in the output of sql query?

1125

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

2165

How would you convert date into julian date format?

1044

what is online transaction processing (oltp)? : Sql dba

1040

What is varchar data type in sql?

1138

What are hotfixes and patches?

986

What is the purpose of normalization?

1086

How we can update the view?

1097

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1124

what is error ora-03113: end-of-file on communication channel?

1227

what is 'trigger' in sql? : Sql dba

1146

what is view? : Sql dba

1029

What is optimistic concurrency control? : Transact sql

1030

Explain exception handling in pl/sql?

1082

Explain cursor types?

1085