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

Explain the use of indexes option in exp command.

599


How to create a table interactively?

574


Please explain joins in oracle?

561


Can multiple columns be used in group by in oracle?

555


How to assign a table row to a record variable?

590






Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

1656


What is a oracle database?

619


How to write a query with a left outer join in oracle?

613


What is Reduced List of Values?

1716


What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

661


How to specify default values in insert statement using oracle?

572


What is oracle and what are its different editions?

585


what are actual and formal parameters?

605


How to write a left outer join with the where clause in oracle?

641


Differentiate between post-database commit and post-form commit?

549