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 are predefined functions in sql?

980

Explain exception handling in pl/sql?

990

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3518

Is vs as in pl sql?

935

When sql appeared?

1025

What are the different ways to optimize a sql query?

891

How do you sort in sql?

954

How to use transactions efficiently : transact sql

993

discuss about myisam index statistics collection. : Sql dba

908

What can I use instead of union in sql?

905

What is delimiter sql?

924

What is a heap in sql?

994

How can we implement rollback or commit statement in a trigger?

981

What is an inner join sql?

956

What are the different types of dbms?

956