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

find out the second highest salary?

Question Posted / elumalai d

55 Answers
89910 Views
Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is an anonymous block?

1258

what is meant by magic query

2191

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2468

What is a partition in oracle?

1127

How to initialize variables with default values?

1250

What is a read write transaction in oracle?

1094

What is the order of defining local variables and sub procedures/functions?

1062

Can select statements be used on views in oracle?

1030

How do we represent comments in oracle?

1057

Explain oracle’s server parameter file.

999

What is the Tune Query

2298

How do I spool to a csv formatted file using sqlplus?

1039

Is oracle an open source?

1084

What is null value in oracle?

1100

Write a syntax for update query in oracle?

1037