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

what is the dual table in oracle?

934

How to define a specific record type?

1037

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

2302

Explain what does a control file contain?

1034

How to change system global area (sga) in oracle?

960

What is a view and how is it different from a table?

973

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2295

Can you create a synonym without having a table?

980

Why do you use stored procedures and state some of its disadvantages?

971

How to define an external table with a text file?

1021

How to sort output in descending order in oracle?

989

What suggestions do you have to reduce the network traffic?

902

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

953

How many categories of data types?

940

How many types of synonyms in Oracle?

1066