SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN (SELECT MAX(SALARY)

how to find the second highest salary from emp table?

Question Posted / chiguru&

Answer Posted / chiguru&

SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN
(SELECT MAX(SALARY) FROM EMPLOYEE)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to load data with sql*loader?

1055

What does the hierarchical profiler does?

1065

What is cursor status?

1193

How do I save a stored procedure?

1013

How do I save the results of sql query in a file?

981

What is equi join in sql?

1084

How does postgresql compare to "nosql"?

1040

Who is the owner of mysql database?

1060

Explain the difference between rename and alias?

1019

Can we insert data into view?

909

what are integrity rules?

1037

What is the purpose of cursors in pl/sql?

1139

Is inner join same as self join?

1123

What is rownum?

987

How do I view a table in sql?

1013