select * from employee e where 3 = (select count(distinct(salary)) from em

find out the third highest salary?

Question Posted / hhh

Answer Posted / hhh

select * from employee e where 3 = (select
count(distinct(salary)) from employee where e.salary <= salary);

Is This Answer Correct ?

0 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Explain about integrity constraint?

1124

How to display row numbers with the records?

1080

How does oracle handle read consistency?

1097

Explain the dml?

983

What is connection pooling in oracle?

973

Are truncate and delete commands same? If so why?

1156

please explain.. DB architecture ...

2023

How to load data from external tables to regular tables?

1062

What is an oracle database table?

1015

What is the difference between formal parameters and actual parameters?

1089

What is a subquery?

1123

How can we create the complete backup of data in the oracle.

2161

What are the original export and import utilities?

1172

How to run create database statement?

1034

What are the limitations of check constraint?

1033