Tom,

Here is what I am doing.

select interest_rate, count(interest_rate)
from volume_statistics where interest_rate between 16.01 and 18
and principal_amount between 10000.01 and 15000
group by interest_rate


INTEREST_RATE COUNT(INTEREST_RATE)
------------- --------------------
16.24 8
16.25 8
16.3 1
16.45 2
16.49 3
16.74 6
16.75 2
16.85 1
16.9 1
16.95 10
16.99 6

INTEREST_RATE COUNT(INTEREST_RATE)
------------- --------------------
17 1
17.24 5
17.25 3
17.35 1
17.45 3
17.49 8
17.74 3
17.75 8
17.85 3
17.94 1
17.95 84

INTEREST_RATE COUNT(INTEREST_RATE)
------------- --------------------
17.99 12
18 28

24 rows selected.


However what I really want the output to be is the highest count or frequency that an apr appears
and obtain that apr.
17.95 84


I tried the following, but get the following error, which makes sense:

select interest_rate, Max(count(interest_rate))
from volume_statistics where interest_rate between 16.01 and 18
and principal_amount between 10000.01 and 15000
group by interest_rate
ERROR at line 2:
ORA-00937: not a single-group group function

I also have to take in account if for some reason the highest counts are the same for 1 + n values.
In this example I would always want the higest interest rate which is 17.74:

INTEREST_RATE COUNT(INTEREST_RATE)
------------- --------------------
17.45 3
17.74 3

I figured I could just put it in a cursor and retrieve the first row if I sort it in DESC order,
however this is a report being run out of a cron via SQR. Plus, I figured you would have an
answer.

Any help would be great.
Thanks,
Chris