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 the difference between numeric and autonumber?

997

What is difference between procedure and trigger?

980

What is the difference between microsoft access and sql?

1023

How to pipe multiline string to isql?

1005

How run sql*plus commands that are stored in a local file?

1061

Can a trigger call a stored procedure?

1070

What is the use of procedures?

975

What is the reports view in oracle sql developer?

991

how can we know the count/number of elements of an array? : Sql dba

1060

Why is sql important?

1106

What is the clause we need to add in function body to return variable?

1012

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1101

What is sql partition?

1106

What is the purpose of cursors in pl/sql?

1135

What are the different dcl commands in sql?

1170