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

What is sharded cluster?

924

What are temporal data types in oracle?

1063

How to rebuild an index in oracle?

968

How to resolve the ORA-39133 error in Oracle?

1031

What is truncate oracle?

915

What are the attributes of the cursor?

933

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2329

What are the different windows events activated at runtime ?

2832

Explain enable novalidate constraint.

1030

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2205

What is define in oracle?

998

Can multiple columns be used in group by in oracle?

926

How to delete all rows a table in oracle?

1007

How to delete multiple rows from a table in oracle?

1003

How to find the duplicate rows count from employees table in oracle?

1037