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

8 Answers
11675 Views
I also Faced
E-Mail Answers

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 rename a tablespace in oracle?

1087

What are the differences between number and binary_float in oracle?

1104

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1384

How do I know if oracle is installed on windows?

931

How to drop a tablespace?

1048

Explain the dml?

987

What are the oracle differences between nvl and coalesce

1149

How to use values from other tables in update statements using oracle?

1082

What are the attributes of the cursor?

1004

What is a dead lock in oracle?

1127

How to drop an existing table in oracle?

1058

What is oracle host variable?

1068

What are data pump export and import modes?

1071

What is the difference between "as" and "is" in an oracle stored procedure?

994

How to create a table index?

1155