how to find the second highest salary from emp table?

Answer Posted / vinay

select max(sal) from emp where rownum = 2;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between alter trigger and drop trigger statements?

606


How can we solve sql error: ora-00904: invalid identifier?

701


What are the different types of tables in sql?

490


How can I get the number of records affected by a stored procedure?

581


What are system versioned tables?

553






what is top in tsql? : Transact sql

551


Is microsoft sql free?

604


What is sql in oracle?

629


What is a primary key? Explain

549


how to extract a unit value from a date and time? : Sql dba

560


what is timestamp in mysql? : Sql dba

570


Can a primary key be a foreign key?

581


How do I add a database to sql?

584


Is it possible to include an insert statement on the same table to which the trigger is assigned?

567


Do we need to rebuild index after truncate?

529