select A.* from employee A where 1=(select count(distinct B.sal) from empl

how to find the second highest salary from emp table?

Question Posted / prasanna

Answer Posted / prasanna

select A.* from employee A where 1=(select count(distinct
B.sal) from employee B where B.sal>A.sal)

Is This Answer Correct ?

63 Yes

71 No

Please Help Members By Posting Answers For Below Questions

can a stored procedure call itself or recursive stored procedure? : Sql dba

1026

What is foreign key sql?

985

What mean sql?

1003

Explain exception handling in pl/sql?

1033

How subquery works in sql?

1067

Why commit is not used in triggers?

1038

what is the use of set statement in tsql? : Transact sql

1008

What are sql commands?

1010

what are aggregate and scalar functions? : Sql dba

1056

What is a call statement? Explain with an example.

1003

What is lookup table in sql?

1042

How does join work in sql?

1007

How do you copy a table in sql?

1066

What is use of package in pl sql?

1010

What are the triggers associated with image items?

1041