SELECT DISTINCT (a.sal) FROM EMP A WHERE 5= ( SELECT COUNT (DISTINCT (b

How to retrieve 5th highest sal from emp table?

Question Posted / aryasen vaikom

Answer Posted / aryasen vaikom

SELECT DISTINCT (a.sal)
FROM EMP A
WHERE 5= ( SELECT COUNT (DISTINCT (b.sal))
FROM EMP B
WHERE a.sal<=b.sal )

Is This Answer Correct ?

5 Yes

2 No

Please Help Members By Posting Answers For Below Questions

how to clone 9i Database on to 10g Database.

1828

Explain the use of consistent option in exp command.

552

What is meant by an index?

624

How to run create database statement?

579

Explain database link?

667

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1474

Write a syntax for update query in oracle?

622

How to convert times to characters in oracle?

609

What do you mean by group by clause?

565

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1567

What is partitioned table in Oracle?

639

What is data file?

619

How to use "out" parameter properly?

634

What are the differences between number and binary_float in oracle?

571

How do I escape a reserved word in oracle?

632