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

What happens to the current transaction if a ddl statement is executed?

978

What are group functions in oracle?

992

What are the most common interview questions on ETL Testing for experience?

1095

How to create a single index for multiple columns?

994

What is the usage of merge statement?

1109

Why do we need integrity constraints in a database?

993

What are the different editions of oracle?

1069

What is hash cluster in oracle?

1115

What do you mean by redo log file mirroring?

994

What are the arithmetic operations?

1041

What is oracle sid?

906

What is the order of defining local variables and sub procedures/functions?

1032

What is translate in oracle?

1068

How to define a variable of a specific record type?

1033

What is private procedure oracle?

975