I have a SQL statement that uses group-by to generate reports as such:
GroupFieldClicks
---
Page 1 50
Page 2 20
Page 3 30
Now, as an added field, I also want it to tell me what percent of
total clicks each row represe
On Mon, Mar 12, 2007 at 12:53:11 -0700,
Mike <[EMAIL PROTECTED]> wrote:
>
> How do I get access to the total of all clicks on per row basis so I
> can divide it? The only solution that comes to my mind is create a
> subquery that does a (select count(*) from... where... ) of the
> original group
