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 are the 'mysql' command line arguments? : Sql dba

1203

How do I view a procedure in sql?

1022

Differentiate pl/sql and sql?

1140

What is pl sql script?

1098

Can you selectively load only those records that you need? : aql loader

1107

What is difference between pl and sql?

1120

how to present a past time in hours, minutes and seconds? : Sql dba

1079

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1072

What are %type and %rowtype for?

1118

What are the advantages of sql? Explain

1163

What is blind sql injection?

1178

What is aggregate function in sql?

1089

Write a unique difference between a function and a stored procedure.

1056

How do I save the results of sql query in a file?

1024

What is sql in oracle?

1116