select * from emp e1 where 2=(select count(distinct salary) from emp e2

how to find the second highest salary from emp table?

Question Posted / manjusha

Answer Posted / manjusha

select * from emp e1
where 2=(select count(distinct salary) from emp e2
where e1.sal<e2.sal);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is sql and how does it work?

1178

What is cursor status?

1190

What is graph sql?

996

Why is normalization important?

1032

What is difference between hql and sql?

1085

What is case function?

1043

What is example of database?

1060

How many aggregate functions are available there in sql?

985

What is the usage of nvl function?

1040

Is and as keyword in pl sql?

962

What is sql constant?

1039

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1071

Why join is faster than subquery?

1116

How to disable a trigger name update_salary?

1266

What is pl sql variable?

994