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 assign values to variables?

1043

How many data types are supported?

1022

What is a oracle database?

992

Explain an index?

1092

What is connection pool in oracle?

926

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

2205

What would you do with an in-doubt distributed transaction?

1914

What are the extensions used by oracle reports?

995

Can we write insert statement in function in oracle?

1025

How to retrieve the count of updated rows?

1054

How to call a stored function with parameters?

968

What are the numeric comparison operations?

1050

Give the different types of rollback segments.

978

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2072

How to lock and unlock a user account in oracle?

1025