RE: I still have trouble wrapping my head around these analytical functions (should be simple?)

Quoting Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>:

> Unfortunately I really do want the rank.
> As far as your analytics example vs. using min() and max () and group by, I
> will compare to see which is more efficient, but I would imagine that they
> are the same.
>

this does the trick, I believe.
better than the one I sent you before, anyway:

  1 select
  2 id, min (value) as smallest, max (value) as largest,   3 count(1) over (order by min(value),max(value)) rank   4 from zzz
  5 group by id
  6* order by 2,3
next...->/

I SMALLEST LARGEST RANK
- ---------- ---------- ----------

x         10         19          1
b         20         20          2
j         20         30          3
c         30         32          4

4 rows selected.

-- 
Cheers
Nuno Souto
from sunny Sydney
--
http://www.freelists.org/webpage/oracle-l