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 fetch the row which has the max value for a column?

1002

Explain the dml?

983

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2357

How to resolve name conflicts between variables and columns?

1031

What is logical backup in oracle?

1018

How to delete a column in an existing table?

1076

Explain what are the characteristics of data files?

1086

How to create a new oracle data file?

1032

Point the difference between translate and replace?

1088

What is the difference between 10g OEM and 11g OEM?

965

How to loop through data rows in the implicit cursor?

1073

What is the dynamic sql in oracle?

1073

How to estimate disk space needed for an export job?

1051

Is oracle the best database?

963

What is coalesce function?

1073