Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: medain function
select avg(a.w)
from
junk a, junk b
having
(ABS(SUM(SIGN(a.w - b.w))) - SUM(DECODE(b.w,a.w,1,0)) <= 0)
group by a.w
/
"Vince Sbrocchi" <vs151001_at_exchange.daytonoh.ncr.com> wrote in message
news:3a8a9826$1_at_rpc1284.daytonoh.ncr.com...
> Hi, I was curious to if there is a median function that exists for an
oracle
> database 8i. I assume the simplest alternative would be some type of
> sub-query that references the index? Any thoughts...let me know.
>
> Thanks in advance,
> Vince
>
>
Received on Wed Feb 14 2001 - 12:30:47 CST