select * from(select rownum r,ename,sal from(select * from emp order by sal

Write query to fetch second maximum salary from employee table.

Question Posted / santosh kumar

4 Answers
7338 Views
Bravura Solutions, HCL, I also Faced
E-Mail Answers

Answer Posted / santosh kumar

select * from(select rownum r,ename,sal from(select * from emp order by sal desc))where r=2;

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 oracle analytical function?

1061

How do I spool in oracle?

962

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2282

What is a table index?

1034

How to enter a new row into a table interactively?

981

Can you drop an index associated with a unique or primary key constraint?

984

What are the attributes of the cursor?

955

Explain an index segment?

1068

What is not equal to in oracle?

963

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1958

Explain the features of oracle?

1001

Can I create users through internet explorer in oracle 10g?

1040

How to start a new transaction in oracle?

1047

What is oracle data type?

917

Explain a segment?

1046