Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL Question - Group By and % results per row - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: SQL Question - Group By and % results per row
Date
Msg-id 20070315205618.GB2156@wolff.to
Whole thread Raw
In response to SQL Question - Group By and % results per row  ("Mike" <akiany@gmail.com>)
List pgsql-general
Tree view 
On Mon, Mar 12, 2007 at 12:53:11 -0700,
  Mike <akiany@gmail.com> 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 grouped by sql statement.

That's how you do it.

pgsql-general by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: [SQL] PostgreSQL to Oracle
Next
From: "Florian G. Pflug"
Date:
Subject: Re: Native type for storing fractions (e.g 1/3)?