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

What are the different types of functions in sql?

1037

Can we rollback after truncate?

1013

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3037

what is top in tsql? : Transact sql

1087

how to shut down the server with 'mysqladmin'? : Sql dba

991

What does count (*) do in sql?

983

What are analytical functions in sql?

1014

What is auto increment in sql?

1098

How to disable a trigger name update_salary?

1251

Can a table contain multiple foreign key’s?

983

Can you have a foreign key without a primary key?

938

Can we use threading in pl/sql?

1021

how to fetch common records from two tables? : Sql dba

1155

Is sql sequential or random?

1012

Is sql injection illegal?

1004