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

What is the best way to do multi-row insert in oracle?

1049

What is Reduced List of Values?

2148

How to filter out duplications in the returning rows using oracle?

1006

How to select an oracle system id (sid)?

1047

What is the sid in oracle?

952

What is a package in oracle?

1081

What is procedure overloading in oracle?

1032

How to initialize variables with default values?

1214

how the indexes are stored in the Oracle Database?

2257

What is a data dictionary and how can it be created?

1117

How to convert characters to dates in oracle?

1077

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1001

How to turn on or off recycle bin for the instance?

1053

How to create a stored program unit?

1194

What is truncate oracle?

960