SELECT salary FROM employee a WHERE &n IN (SELECT COUNT(*) FROM emp

how to find the second highest salary from emp table?

Question Posted / mallika

Answer Posted / mallika

SELECT salary FROM employee a
WHERE &n IN (SELECT COUNT(*) FROM employee b
WHERE a.salary <= b.salary)

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Why do we need databases?

987

What is the maximum database size for sql express?

962

What is materialized view in sql?

875

How to select unique records from a table?

1002

What is a subquery in sql?

977

What is cursor status?

1135

How to convert comma separated string to array in pl/sql?

1112

Which table is left in left join?

956

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

899

What is nvl?

1018

what is a tablespace? : Sql dba

1007

Can I join the same table twice?

996

Enlist the advantages of sql.

939

Explain alias in sql?

997

What is acid property in a database?

974