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

Explain what does a control file contain?

1063

How do I uninstall oracle 11g?

1077

Is the After report trigger fired if the report execution fails ?

2887

What are the arithmetic operations?

1048

Point the difference between translate and replace?

1046

Which is faster join or subquery in oracle?

954

How to get last row id?

958

how may join possible between (requisition with purchase order)

2200

What is meant by a deadlock situation?

1077

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1974

How to install oracle odbc drivers?

1058

What is an oracle function?

1108

Can objects of the same schema reside in different tablespace?

1026

How to change user password in oracle?

990

What is the data pump import utility?

1001