select a.empno,a.ename,a.sal from emp a where &n = (select count(disti

find out the third highest salary?

Question Posted / dayaram & sarfaraz (dost)

Answer Posted / dayaram & sarfaraz (dost)

select a.empno,a.ename,a.sal from emp a
where &n = (select count(distinct(b.sal)) from emp b where
b.sal>= a.sal

Is This Answer Correct ?

0 Yes

5 No

Please Help Members By Posting Answers For Below Questions

How to drop an existing view in oracle?

992

Is oracle a language?

989

Differentiate between pre-select and pre-query?

1156

How to do paging with oracle?

1053

What is the sid in oracle?

1033

What is Data Dictionary Cache in Oracle?

1244

How to check database size in Oracle?

1257

What are nested tables?

1227

How to speed up webrick?

1125

How to execute a stored program unit?

1128

What is an oracle wallet?

993

How to create a table interactively?

1167

Explain the use of Merge statement in oracle 11g

1077

What happens if you set the sga too low in oracle?

1223

Explain about the analyze command in oracle?

1113