selec * from emp e1 (n-1)=(select count(distinct(sal) from emp e2 where e

find out the second highest salary?

Question Posted / naveen

Answer Posted / naveen

selec * from emp e1 (n-1)=(select count(distinct(sal) from
emp e2 where e1.sal<=e2.sal))

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

List out the types of joins.

593

How to do clean up if create database failed?

576

What is a Garbage Collection? and what is full recursive Garbage collection?

2389

What is sequence?

624

How to update values in a table in oracle?

579

How to create an oracle database manually?

568

Explain the use of record option in exp command.

533

How to select all columns of all rows from a table in oracle?

589

What are the types of trigger in oracle?

573

What is the difference between count (*), count (expression), count (distinct expression)?

558

How to start an oracle instance?

574

Is a rollback possible to any savepoint?

556

What is BBED in Oracle?

685

How can I introduce multiple conditions in like operator?

553

How do I start tns listener?

542