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

what is a materialized view? : Sql dba

1048

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1042

What is cte sql?

971

Does a primary key have to be a number?

952

Can we use pl sql in mysql?

997

What is the difference between delete, truncate and drop command?

1126

How to call a javascript function from pl sql?

1119

Can we delete column in sql?

1078

What is the left table in sql?

952

What does stand for in sql?

952

How do sql triggers work?

1022

What is union and union all keyword in sql?

1018

Is full outer join same as cross join?

952

What are functions in sql?

936

Explain the difference between rename and alias?

1003