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 compound trigger?

995

Explain what is a subquery ?

1137

What is a sql instance vs database?

1066

what is the difference between a having clause and a where clause? : Sql dba

1042

Explain constraints in sql?

1009

How to test for null values?

1005

How do you write an inner join query?

915

How many types of primary keys are there?

1000

What is the difference between pl and sql?

1061

What packages are available to pl/sql developers?

1012

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

1044

Does execute immediate commit?

1178

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

913

Explian rowid, rownum?

977

What is pragma in sql?

1043