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
11711 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

What is a table index in oracle?

1136

What the is the diff between local index and global index. give some example.

1648

How to connect asp pages to oracle servers?

1084

What are the different types of modules in oracle forms?

1008

What is rowid and rownum in oracle?

1019

What is query image?

985

What is system tablespace?

1108

What is the difference between postgresql and oracle?

1063

How to delete multiple rows from a table in oracle?

1072

What happens if the imported table already exists?

1042

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2073

What is oracle database client?

1041

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2038

Where do we use decode and case statements?

1023

What is the quickest way to fetch the data from a table?

1067