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 does (*) mean in sql?

522

Explain how to use transactions efficiently : transact sql

523

What problem one might face while writing log information to a data-base table in pl/sql?

548

How to install oracle sql developer?

559

What type of database is sql?

611

What can I use instead of union in sql?

503

What is the difference between function and procedure in pl/sql?

530

What is user in sql?

571

Is natural join same as inner join?

499

What are views in sql?

536

what are the non-standard sql commands supported by 'mysql'? : Sql dba

569

What is oracle sql called?

500

what is cursor. write example of it. What are the attributes of cursor.

739

How do I run sql profiler?

577

What do you mean by “trigger” in sql?

611