select name,salary from emp where salary=(select min(sal) from (select di

find out the third highest salary?

Question Posted / santhoshkumar

Answer Posted / santhoshkumar

select name,salary from emp where salary=(select min(sal)
from (select distinct TOP 3(salary) from emp order by
salary desc;

Is This Answer Correct ?

5 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is an oracle data file?

1103

How would you best determine why your MVIEW couldnt FAST REFRESH?

1889

What is an Oracle index?

1655

How to resolve name conflicts between variables and columns?

1031

How to drop an existing view in oracle?

946

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1999

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2827

What is the data pump import utility?

1035

How many types of tables are there in oracle?

1061

How do you store pictures in a database?

1006

What do you mean by cdb and pdb in oracle 12c?

1059

How to specify default values in insert statement using oracle?

1104

What is Java Pool in Oracle?

1169

Is there a function to split a string in plsql?

1056

What language does oracle use?

1100