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

What is sql key?

1043

What is PL/SQL Records?

1253

What is a Mapplet?

1194

can a stored procedure call itself or recursive stored procedure? : Sql dba

1084

What is the purpose of my sql?

1010

Can we group by two columns in sql?

1046

what is a database transaction? : Sql dba

1255

Does sql full backup truncate logs?

1079

What is sqlcommand?

1071

what is the use of set statement in tsql? : Transact sql

1059

What is sql query optimization?

1192

Is delete faster than truncate?

1051

Explain the difference between 'between' & 'and' operators in sql

1044

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1055

What are the parameter modes supported by pl/sql?

1152