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

Why packages are used in oracle?

1077

What is an oracle transaction?

1156

What is procedure overloading in oracle?

1066

What's dateware house and what's clustor with practicle example

2185

how to make an oracle object

2366

How to use "in out" parameter properly?

1055

What are the different types of modules in oracle forms?

1006

How to create an oracle testing table?

1078

How will you identify oracle database software release?

1018

What privilege is needed for a user to create tables in oracle?

956

How to create a new table in your schema?

1088

What is where clause in oracle?

1039

How to best split csv strings in oracle 9i?

1050

What is a tns file?

1004

How to create a new oracle data file?

1039