How to retrieve 5th highest sal from emp table?

Answer Posted / jithendranath.g

select z2.sal from emp z1, emp z2
where z2.sal <=z1.sal
group by z2.sal
having count(z2.sal)=&n

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 count duplicated values in a column in oracle?

554


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.

1531


What is recovery manager in Oracle?

589


What is the difference between $oracle_base and $oracle_home?

585


How oracle handles dead locks?

600






Explain oracle’s server parameter file.

564


Is postgres faster than oracle?

561


What is oracle join syntax?

570


How to put more than 1000 values into an oracle in clause?

586


How to import one table back from a dump file?

591


How do I limit the number of oracle database connections generated by weblogic server?

543


How to run queries on external tables?

567


How to use in conditions in oracle?

552


What are group functions in oracle?

583


Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

1877