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

How to sort the query output in oracle?

972

What are the attributes that are found in a cursor?

1013

Explain about integrity constraint?

1082

Where are the settings stored for each instance in oracle?

1065

What are the database administrators utilities available?

976

What is a nvl function? How can it be used?

961

Whether any commands are used for months calculation? If so, what are they?

1042

What are operators in oracle?

1013

What is the maximum limit on the number of columns in a table?

1012

Give the constructs of a package, function or a procedure.

988

what is reindexing?

1612

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2047

Is oracle a language?

902

How to drop a stored function?

1087

Explain self joins in oracle?

951