how to find the second highest salary from emp table?

Answer Posted / jitendra kumar

select salary from (select salary from emp ordery by salary
(dese) where rownum>=2;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we delete column in sql?

563


What is the difference between nvl function, ifnull function, and isnull function?

590


What is a system versioned table?

538


What is the most common sql injection tool?

545


what is a unique key ? : Sql dba

547






what is 'mysqlcheck'? : Sql dba

574


What will you get by the cursor attribute sql%found?

537


How do I copy a table in sql?

517


What is trigger with example?

565


Explain cursor types?

581


What does pl sql developer do?

510


Define commit?

551


Explain what is rdbms?

583


What is constant in pl sql?

519


Why cannot I use bind variables in ddl/scl statements in dynamic sql?

668