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 we edit a view in sql?

984

What is percent sign in sql?

1283

Which nosql database is best?

975

What are the different types of tables in sql?

1009

Define implicit and explicit cursors.

1145

What is difference between db2 and sql?

1001

What is insert command in sql?

1131

How do you modify a trigger?

928

What is a database? Explain

1112

Which table is left in left join?

1014

What are different types of functions in sql?

1004

What is sqlca in db2?

970

What is the main reason behind using an index?

1018

which tcp/ip port does sql server run on? : Sql dba

1026

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

1068