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

How to get a create statement for an existing table?

969

What is snapshot is too old? Give and example for better understand.

1603

How to write numeric literals in oracle?

1185

What is an oracle table?

989

what is the difference between substr and instr function in oracle?

1090

What is a initialization parameter file in oracle?

1035

What is tns service name?

1126

how to join query for one source type is oracle another source type is sql server ?

2426

Design database draw er diagram for a certain scenario ?

4579

How to resolve the ORA-39133 error in Oracle?

1122

What are the uses of linked server and explain it in detail?

1061

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2124

How to manage transaction isolation level?

1006

How different is ms access and oracle?

1040

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2276