select salary from employee e1 where 2=(select count(*) from employee e2

Write a query to find second highest salary of an employee.

Question Posted / mubin ahmad

Answer Posted / mubin ahmad

select salary from employee e1 where 2=(select count(*)
from employee e2 where e2.salary>=e1.salary)

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Why plvtab is considered as the easiest way to access the pl/sql table?

1193

What version is sql?

1005

What is full join?

930

Can we use threading in pl/sql?

1018

what is innodb? : Sql dba

1084

Can we join same table in sql?

993

Explain raise_application_error.

1077

what is a database? : Sql dba

1140

Does sql full backup truncate logs?

1006

how to drop an existing index in mysql? : Sql dba

1052

What is a temporal table?

915

what are all different types of collation sensitivity? : Sql dba

965

Why do we need cursors in pl sql?

1059

What are the different schemas objects that can be created using pl/sql?

1000

what are the advantages a stored procedure? : Sql dba

961