Select * from emptable e1 where(N=(select count(DISTINCT(e2.empsal))from

find out the third highest salary?

Question Posted / shashi kumar

Answer Posted / shashi kumar

Select * from emptable e1 where(N=(select
count(DISTINCT(e2.empsal))from emptable e2 where
e2.empsal>=e1.empsal))

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

When do you get a .pll extension in oracle? Explain its importance

987

How to create lov dynamically at runtime & attach to text field?

1098

How many types of synonyms in Oracle?

1066

How to write a query with an inner join in oracle?

976

What is the difference between a primary key & a unique key?

1042

What is the use of oracle?

984

What is the difference between alert log file and tarce file ?

2099

What is an oracle user role?

939

How to list all user accounts in oracle?

981

What is oracle update statement with inner join ?

995

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

2302

What is oracle rownum?

888

How to export data to a csv file?

1206

How to rename an index?

997

What is a table index?

1014