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

find out the second highest salary?

Question Posted / shalini

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

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to specify default values in insert statement using oracle?

1111

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2212

How to change program global area (pga) in oracle?

1096

When system tablespace is created?

1046

List the types of joins used in writing subqueries?

998

What happens in oracle commit?

1033

What are the components of logical database structure in oracle database?

1088

what happened to the global index when I truncate the data in one of the partition?

2023

What are the logical operations?

1126

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2284

What is the difference between Delete, Truncate and Drop in Oracle?

1131

How to select some columns from a table in oracle?

1097

What are the types of trigger in oracle?

984

Explain a data segment?

1072

How to generate query output in html format?

1122