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 the maximum number of columns in sql table?

1089

how can you see all indexes defined for a table? : Sql dba

936

What is plpgsql language?

980

what is the difference between group by and order by in sql? : Sql dba

1061

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1116

How do I pipe the output of one isql to another?

945

Differentiate between syntax and runtime errors.

1120

What is a system versioned table?

932

what are different types of keys in sql?

1067

How do you update f as m and m as f from the below table testtable?

1792

how to include character strings in sql statements? : Sql dba

1001

what is bcp? When is it used?

1049

differentiate between float and double. : Sql dba

992

Can sql developer connect to db2?

989

What is sqlca in db2?

895