select * from emp e1 where (3=(select count(distinct (e2.sal))from emp e2

find out the second highest salary?

Question Posted / padiya hiten

Answer Posted / padiya hiten

select * from emp e1 where (3=(select count(distinct
(e2.sal))from emp e2 where e2.sal>=e1.sal));

Is This Answer Correct ?

4 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Give the various rollback segment states.

579

How to create a table in a specific tablespace?

539

How to define a procedure inside another procedure?

541

How to convert characters to numbers in oracle?

595

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1484

how can we store any pdf file in oracle

1638

How to rebuild an index in oracle?

547

Does oracle database need java?

520

What is meant by an index?

619

How to write a query with a left outer join in oracle?

603

How many categories of data types?

570

How to define a sub function?

662

What is a nested table and how is it different from a normal table?

573

What happens to the data files if a tablespace is dropped?

574

Difference between oracle's plus (+) notation and ansi join notation?

570