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 are the different windows events activated at runtime ?

2898

How many types of synonyms in Oracle?

1119

How to select all columns of all rows from a table in oracle?

1052

Explain oracle instance.

1171

How to shutdown your 10g xe server?

1147

What is the data pump export utility?

1079

How to display row numbers with the records?

1075

What is a initialization parameter file in oracle?

1035

Difference between inner join vs where ?

1033

What is a nvl function? How can it be used?

1029

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1077

What is blob datatype?

1124

How to delete all rows a table in oracle?

1068

Explain the use of Merge statement in oracle 11g

1027

WHAT IS ecc 6.0

2147