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 a data dictionary and how can it be created?

617

How to use select statement to count the number of rows in oracle?

560

How to define a data source name (dsn) in odbc manager?

533

What is the purpose of tables, private synonyms and public synonyms in Oracle?

593

What is object data modeling?

507

How to write date and time literals in oracle?

559

Can you drop an index associated with a unique or primary key constraint?

587

How to load excel data sheet to oracle database

592

How can you merge two tables in oracle?

573

What is the scope of a local variable?

587

How to create a new view in oracle?

624

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

548

How can windows applications connect to oracle servers?

524

How to start instance with a minimal initialization parameter file?

542

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

1956