SELECT ID,NAME,SAL,ROWNUM FROM EMP ORDER BY ID DESC WHERE ROWNUM=2

find out the second highest salary?

Question Posted / shalini

Answer Posted / shalini

SELECT ID,NAME,SAL,ROWNUM
FROM EMP
ORDER BY ID DESC
WHERE ROWNUM=2

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

1879

How to save query output to a local file?

563

what is dynamic SGA and static SGA

3837

Explain the use of rows option in exp command.

585

How will you differentiate between varchar & varchar2?

590

Explain the dml?

599

How to write numeric literals in oracle?

611

What is recycle bin in Oracle?

720

What are the limitations of check constraint?

573

What is the dynamic sql in oracle?

597

What are internal user account in oracle?

571

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

3870

What are the differences between interval year to month and interval day to second?

552

Is postgres faster than oracle?

561

How to run create database statement?

579