SELECT MAX(sal) FROM EMP WHERE sal NOT IN (SELECT MAX(sal) FROM emp)

how to calcuate the second highest salary of he employee

Question Posted / neetika vardhan

Answer Posted / neetika vardhan

SELECT MAX(sal)
FROM EMP WHERE sal NOT IN (SELECT MAX(sal) FROM emp)

Is This Answer Correct ?

42 Yes

3 No

Please Help Members By Posting Answers For Below Questions

explain what is mysql? : Sql dba

1086

Is sql a case sensitive language?

950

What is sql partition?

1112

what is rdbms? : Sql dba

1018

How does rowid help in running a query faster?

1417

Do we need to rebuild index after truncate?

1036

What can I use instead of union in sql?

970

what is the bond code in materialized view?

3004

what are the differences between binary and varbinary? : Sql dba

1047

Why is sharding used?

1004

What are commit, rollback, and savepoint?

999

How to run sql commands in sql*plus?

1186

What are the two parts of design view?

1020

Differentiate between syntax and runtime errors.

1193

How to add new employee details in an employee_details table with the following details

1091