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

Describe different types of general function used in sql?

1048

what is commit? : Sql dba

1085

Can we create a trigger on view?

905

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1104

what is foreign key? : Sql dba

1066

how to dump a table to a file with 'mysqldump'? : Sql dba

1045

What is the benefit of foreign key?

1030

How many clustered indexes can you have?

983

How do you optimize a stored procedure in sql?

970

What does bitemporal mean?

1080

Is join and inner join the same?

1016

Explain the difference between sql and mysql.

1069

What is the execution plan in sql?

1038

What is not in sql?

956

How to prepare for oracle pl sql certification?

1078