select * from (select distinct sal from emp order by sal desc) where r

find out the third highest salary?

Question Posted / swaminathan

Answer Posted / swaminathan

select *
from (select distinct sal from emp order by sal desc)
where rownum <= 3

Is This Answer Correct ?

9 Yes

13 No

Please Help Members By Posting Answers For Below Questions

How to invoke the data pump export utility?

1193

How to loop through data rows in the implicit cursor?

1080

What is ceil and floor in oracle?

1073

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

1086

query optmization techniques and quwry analyser+projects+ppts

2425

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4178

Query to retrieve record for a many to many relationship ?

2523

How to do clean up if create database failed?

1034

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2069

What is memory advisor in Oracle?

1080

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2106

How many types of tables are there in oracle?

1062

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2050

How do I reset a sequence in oracle?

1106

What happens if you use a wrong connect identifier?

1070