how to find the n'th highest salary from emp ?

Answer Posted / nusrath sultana

select * from emp
where &n=(select count(distinct(sal)) from emp b
where emp.sal<b.sal)

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 call a stored function in oracle?

580


What is merge statement used for?

578


Explain the importance of .pll extension in oracle?

561


Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1551


In oracle there is column command, how will you explain that?

556






How can windows applications connect to oracle servers?

530


How to write date and time literals in oracle?

564


What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

551


Can we insert data in view oracle?

547


How to delete a user account in oracle?

558


What is save point in oracle database?

735


What is using clause and give example?

593


How to define an anonymous block?

626


What happens if the imported table already exists?

553


What is the difference between a primary key & a unique key?

595