select sal from emp a where $number = (select count(distinct(sal)) from e

how to find the second highest salary from emp table?

Question Posted / shalina bajaj

Answer Posted / shalina bajaj

select sal from emp a
where $number = (select count(distinct(sal))
from emp b
where a.sal <= b.sal);

Is This Answer Correct ?

11 Yes

17 No

Please Help Members By Posting Answers For Below Questions

How do I sort a table in sql?

1038

What is the file extension for sql database?

997

How to revise and re-run the last sql command?

1161

What are the packages in pl sql?

1009

What are the types pl/sql code blocks?

1122

What is mutating trigger?

1017

explain the options of myisamchk to improve the performance of a table. : Sql dba

1006

What are the events on which a database trigger can be based?

1180

what are numeric data types? : Sql dba

1058

What is a database event trigger?

1156

What is sql constant?

1025

Why we use pl sql?

955

What does partition by mean in sql?

956

What is primary and foreign key?

1058

Which is better varchar or nvarchar?

994