Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: I still have trouble wrapping my head around these analytical functions (should be simple?)
What about
select distinct id, smallest, largest, rank () over (order by smallest,
largest) as rank
from (
select distinct id, smallest, largest
from
(select id
, min(value) over (partition by id) smallest , max(value) over (partition by id) largestfrom zzz
Analytic functions all the way :-)
jan
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 30 2006 - 20:59:33 CST
![]() |
![]() |