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 difference between execution of triggers and stored procedures?

1158

Which join is default?

1016

How does sql store data?

959

Is join an inner join?

1026

How does join work in sql?

1054

What does seeding a database mean?

1024

Which operator is used in query for pattern matching?

1133

How delete all data from table in sql?

1077

Why indexing is needed?

1046

What are aggregate functions in sql?

1225

Why do we use procedures in pl sql?

1076

Does sql support programming?

1115

What packages(if any) has oracle provided for use by developers?

5883

Define commit, rollback and savepoint?

1081

Give the order of sql select?

1187