select distinct sal from Employee e1 where 3 = (select count(distinct

find the second highest salary of the emp table

Question Posted / chiru

Answer Posted / chiru

select distinct sal
from Employee e1
where 3 = (select count(distinct sal) from Employee e2
where e2.sal >= e1.sal)
order by sal desc

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain about integrity constraint?

1078

What is execute immediate in oracle?

951

What are the restrictions in a oracle read only transaction?

969

Difference between open_form and call_form in oracle.

1094

What is user managed backup in Oracle?

1078

How to shutdown your 10g xe server from command line?

1015

What are the advantages of oracle?

963

Can group functions be used in the order by clause in oracle?

940

What are the differences between date and timestamp in oracle?

974

Explain the use of parfile option in exp command.

991

Is a rollback possible to any savepoint?

1001

How to commit the current transaction in oracle?

1047

How to invoke the original export import utilities?

977

Explain what are the characteristics of data files?

1031

Can select statements be used on views in oracle?

985