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

How can you use check constraints for self referential integrity?

1013

How can we find out the duplicate values in an oracle table?

1116

Explain the types of exception?

1191

Can we save images in a database and if yes, how?

1108

How to invoke the data pump export utility?

1251

How do you bind variables in oracle?

1018

Can select statements be used on views in oracle?

1082

Can we commit inside a function in oracle?

1010

What is the difference between $oracle_base and $oracle_home?

1136

What is catalog in Oracle?

1432

What is recovery manager(rman) backup in Oracle?

1229

please explain.. DB architecture ...

2080

what is difference between sql plus and sql*plus? (not sql and sql plus).

3941

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2061

What are the different types of database objects?

1114