How to Select second Maximum salary in a Table ?

Answer Posted / ranjini

select max(salary) from employee not exists (select
max(salary)from employee)

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to connect to oracle using service name instead of sid?

553


How to insert a new row into a table in oracle?

594


Where do you use decode and case statements?

556


What is recovery manager(rman) backup in Oracle?

630


What is recycle bin in Oracle?

722






How do I manually uninstall oracle client?

520


Explain joins in oracle?

561


What is a named program unit?

585


What are the arithmetic operations?

592


Please explain joins in oracle?

551


When do I need to use a semicolon vs a slash in oracle sql?

594


What is the scope of a local variable?

587


Which is faster join or subquery in oracle?

537


Please explain drop constraint oracle?

631


Give the various rollback segment states.

581