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

how to get second highest salary in SQL(as/4000

Question Posted / raji_4u

Answer Posted / raji_4u

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

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do you select unique values in sql?

1000

What are the possible values for the boolean data field?

963

what is innodb? : Sql dba

1106

What is a Mapplet?

1120

Which are the different character-manipulation functions in sql?

1065

define sql update statement ? : Sql dba

1123

What is the difference between cluster and non-cluster index?

1108

What is left join in postgresql?

1047

What is the requirement of self-join?

1133

What do you mean by table in sql?

991

How do I find duplicates in the same column?

1087

What is before trigger?

1004

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1064

Does sql use python?

1035

What is anonymous block in sql?

1121