how to find the second highest salary from emp table?

Answer Posted / tanmoy

SELECT MIN(sal) FROM (SELECT sal FROM emp ORDER BY sal DESC LIMIT 2) AS a ;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mutating error in pl sql?

553


Why plvtab is considered as the easiest way to access the pl/sql table?

623


What is the use of <> sql?

556


What is query execution plan in sql?

571


Explain ttitle and btitle.

674






What is an oracle stored procedure?

593


What is function and procedure in pl sql?

523


Why trigger is used in sql?

535


Can you sum a count in sql?

562


what is text? : Sql dba

564


Is a secondary key the same as a foreign key?

493


what is the difference between primary key and unique key? : Sql dba

532


how to enter numeric values as hex numbers? : Sql dba

571


How do I save a stored procedure?

527


Can ddl statements be used in pl/sql?

597