SELECT MAX(SAL) FROM EMP A WHERE SAL NOT IN(SELECT MAX(SAL) FROM EMP B);

Write a query to find second highest salary of an employee.

Question Posted / satheesh

Answer Posted / satheesh

SELECT MAX(SAL) FROM EMP A
WHERE SAL NOT IN(SELECT MAX(SAL) FROM EMP B);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can primary key be changed?

952

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1104

Why do we use partitions in sql?

1096

What is sql injection vulnerability?

1005

Does truncate free space?

1064

How can you tell the difference between an index and a view?

977

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

998

What is the use of double ampersand (&&) in sql queries? Give an example

1189

Why query optimization is needed?

973

Does a user_objects view have an entry for a trigger?

1049

What are the operators used in select statements?

1100

Why do we need unique key in a table?

1004

What is a schema sql?

1226

What is data control language?

1032

What is Collation Sensitivity ? What are the various type ?

1001