Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Calcuate percentage. - Mailing list pgsql-general

From Kaare Rasmussen
Subject Re: [GENERAL] Calcuate percentage.
Date
Msg-id 199903100614.HAA04710@bohr.webline.dk
Whole thread Raw
In response to Re: [GENERAL] Calcuate percentage.  (Clark Evans <clark.evans@manhattanproject.com>)
List pgsql-general
Tree view 
> P.S.  In oracle, I'd use a sub-query:
>
> SELECT var, COUNT(*) / total_count
>   FROM temp,
>        ( SELECT COUNT(*) AS total_count
>            FROM temp
>        )
> GROUP BY var;

I thought that subqueries were allowed in PostgreSQL after 6.2?

pgsql-general by date:

Previous
From: Michael Davis
Date:
Subject: RE: [GENERAL] SQL Question
Next
From: Remigiusz Sokolowski
Date:
Subject: Re: [GENERAL] i want to start automaticly postgres when a reboot my server...help please.....