how to get second highest sal of emp table

Answer Posted / yadunandan

select max(sal) from emp where sal<(select max(sal) from
emp)

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a snapshot log?

564


when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1477


What is the difference between $oracle_base and $oracle_home?

585


Explain what are the type of synonyms?

582


What is oracle datasource?

556






What is the difference between substr and instr?

521


Is oracle a relational database?

523


Name the three major set of files on disk that compose a database in Oracle?

635


What is oracle join syntax?

570


What is a sub query? Describe its types?

549


How to select some rows from a table in oracle?

598


Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1276


Give the constructs of a package, function or a procedure.

543


What exactly do quotation marks around the table name do?

546


What are the original export and import utilities?

573