select max(sal) from Table where sal not in(select max(sal) from Table);

How to Select second Maximum salary in a Table ?

Question Posted / guest

13 Answers
15832 Views
Oracle, I also Faced
E-Mail Answers

Answer Posted / guest

select max(sal) from Table
where sal not in(select max(sal) from Table);

Is This Answer Correct ?

20 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain about integrity constraint?

1136

Please explain oracle left join with an example?

1055

how the indexes are stored in the Oracle Database?

2279

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1018

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1965

What is set operator oracle?

992

What is the relation of a user account and a schema in oracle?

1087

What are the arithmetic operations?

1091

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1671

How can windows applications connect to oracle servers?

1069

What is private procedure oracle?

1020

Name the various constraints used in oracle?

1033

What are temporal data types in oracle?

1130

What is ADDM Advisor in Oracle?

1188

How do I escape a reserved word in oracle?

1210