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 where clause in oracle?

628

What is private procedure oracle?

603

How do I limit the number of oracle database connections generated by weblogic server?

650

how to make an oracle object

1938

List out the components of logical database structure of oracle database.

662

How to assign a table row to a record variable?

659

What is difference between cartesian join and cross join?

658

How to manage transaction isolation level?

649

What types of joins are used in writing subqueries?

641

What is the difference between pre-select and pre-query?

713

How to export data with a field delimiter?

662

Explain the use of record length option in exp command.

682

What language does oracle use?

713

How to shutdown your 10g xe server from command line?

643

What are advantages of dateset in datastage?

1870