select min(sal) from (select * from emp order by sal desc) where rownum<

how to select second mauximum value in a given table under salary column

Question Posted / shri

6 Answers
9519 Views
Sapient, I also Faced
E-Mail Answers

Answer Posted / shri

select min(sal) from (select * from emp order by sal desc) where rownum<3

IN Informatica also use the query in source qualifier's
"sql override". which will reduce d no. of t/r in d mapping

Is This Answer Correct ?

3 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the arithmetic operations?

1065

How can Oracle users be audited?

1091

Write a trigger example in oracle?

1032

What are the differences between lov and list item?

1045

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2003

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1027

What is a lookup table in oracle?

963

How to define an explicit cursor in oracle?

1012

What is ADDM Advisor in Oracle?

1158

How to see free space of each tablespace?

1017

What is an oracle transaction?

1114

What is index-organized table in Oracle?

1053

What are the differences between blob and clob in oracle?

1066

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?

1929

WHAT IS ecc 6.0

2139