select z2.sal from emp z1, emp z2 where z2.sal <=z1.sal group by z2.

How to retrieve 5th highest sal from emp table?

Question Posted / jithendranath.g

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

Please Help Members By Posting Answers For Below Questions

How to add a new column to an existing table with a default value?

1001

What privilege is needed for a user to query tables in another schema?

957

How many memory layers are in the oracle shared pool?

1160

What is integrity and what is constraint??Explain with example

2258

How to display employee records who gets more salary than the average salary in the department?

1039

How to recover a dropped table in oracle?

1022

Which environment variables are absolutely critical in order to run the OUI?

2104

Is there any function in oracle similar like group_concat of mysql?

1036

How to delete an existing row from a table in oracle?

1052

What is a data dictionary and how can it be created?

1117

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1986

What do you mean by a deadlock?

1051

How to check the server version in oracle?

1077

What are the differences between lov and list item?

1045

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2604