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

Explain foreign key in sql?

1035

What are analytic functions in sql?

1030

how to fetch common records from two tables? : Sql dba

1177

what is primary key? : Sql dba

1033

Explain what is table in a database?

1062

What is trigger and types?

1030

what is column? : Sql dba

1006

What is sqlerrm?

941

What are the types of subqueries?

1055

What is lexical units in pl sql?

1151

What is pl/sql language case sensitive?

1131

Why truncate is used in sql?

1009

what is bcp? When does it used? : Sql dba

991

What does partition by mean in sql?

967

How to take user input in pl sql?

1167