select max(sal) from emp where sal < (select max(sal) from emp)

Anybody can tell me, how do we find second largest emp
salary from emp table.. Thanks in advance ...

Question Posted / raj

Answer Posted / raj

select max(sal) from emp where sal < (select max(sal) from
emp)

Is This Answer Correct ?

31 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the implicit cursor in oracle?

1171

What happens if you set the sga too low in oracle?

1223

master table and child table performances and comparisons in Oracle ?

2198

Why do we need oracle client?

1008

How to use attributes of the implicit cursor in oracle?

1063

How to upsert (update or insert into a table)?

1043

How to pass parameters to procedures in oracle?

1082

How to rename an existing table?

1218

Explain the difference between a procedure and a function? What do you understand by those terms?

1134

Where do you use decode and case statements?

1044

Can you tell me how to add new column in existing views?how?How is possible?

1515

State and explain about oracle instance?

1052

What is oracle database client?

1081

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1789

query optmization techniques and quwry analyser+projects+ppts

2467