SELECT * FROM (SELECT salary FROM emp ORDER BY salary DESC) WHERE ROWNUM<

find out the second highest salary?

Question Posted / elumalai d

Answer Posted / elumalai d

SELECT * FROM (SELECT salary FROM emp ORDER BY salary DESC) WHERE ROWNUM<3;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the simplest tool to run commands on oracle servers?

513

Is a rollback possible to any savepoint?

556

How to use values from other tables in update statements using oracle?

564

query optmization techniques and quwry analyser+projects+ppts

1925

How to insert a record into a table?

636

How to get maxsal , minsal, ename department wise in single query

1014

How to drop an existing table in oracle?

589

Explain the use of constraints option in exp command.

558

How to best split csv strings in oracle 9i?

584

What is oracle update statement with inner join ?

579

How to create a stored program unit?

578

List the types of joins used in writing subqueries?

573

How to rename an index?

588

What are the database administrators utilities available?

576

can u plz provide me oca sql dumps please i need them

1466