select distinct sal from emp e where 2=(select count(distinct sal)from emp

how to find the second highest salary from emp table?

Question Posted / sankar sasmal

Answer Posted / sankar sasmal

select distinct sal from emp e where 2=(select count(distinct sal)from emp s where e.sal<=s.sal)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Why is %isopen always false for an implicit cursor?

1101

What is the difference between delete and truncate commands?

1036

what are all the common sql function? : Sql dba

1057

What are the syntax and use of the coalesce function?

1202

What is the difference between partitioning and sharding?

1005

what is 'mysqlshow'? : Sql dba

1022

What packages are available to pl/sql developers?

1045

What is a .db file?

984

What are schema-level triggers?

1099

Is microsoft sql free?

1095

What is number function in sql?

965

What is oracle pl sql developer?

978

What is sqlite format?

1191

What is the difference between function, procedure and package in pl/sql?

1252

What is difference between sql and excel?

1088