Re: analytic function of percent of total

From: Tim Gorman <tim_at_evdbt.com>
Date: Thu, 21 Feb 2008 14:04:30 -0700
Message-ID: <20080221140430.kx5p6icuo804kscs@webmail.evdbt.com>


RATIO_TO_REPORT() over (...)

Quoting Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>:

> Isn't there an analytical function that computes each rows value as a
> percent of the total of all rows?
>
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 21 2008 - 15:04:30 CST

Original text of this message