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

Explain view?

577

What is a read only transaction in oracle?

598

How to delete all rows a table in oracle?

625

What would you do with an in-doubt distributed transaction?

1470

What is the difference between a hot backup and a cold backup in oracle?

577

How to display employee records who gets more salary than the average salary in the department?

599

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

1953

What is the oracle implicit cursor?

596

How to define default values for formal parameters?

598

Explain an exception?

568

Which environment variables are absolutely critical in order to run the OUI?

1659

How to delete a column in an existing table in oracle?

603

What is a user role in oracle?

613

What is the relation of a user account and a schema in oracle?

592

State all possible different index configurations a table can possibly have?

572