| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Roberto Mello" <rmello(at)cc(dot)usu(dot)edu>, "Yan Bai" <annie_job(at)hotmail(dot)com> |
| Cc: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Difference between Access97 and PostgreSQL |
| Date: | 2002-02-01 00:29:44 |
| Message-ID: | GNELIHDDFBOCMGBFGEFOKEDPCBAA.chriskl@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> On Wed, Jan 30, 2002 at 11:54:56PM +0000, Yan Bai wrote:
> >
> > --------------------------------------------------
> > SELECT temp.rating, temp.avgage
> > FROM (SELECT s.rating, AVG(s.age) as avgage
> > FROM sailors s GROUP BY s.rating) as temp
>
> Have you tried this query without the subselect? It looks like it should
> work.
What about this?
SELECT temp.rating, temp.avgage
FROM (SELECT s.rating, AVG(s.age) as avgage
FROM sailors s GROUP BY s.rating, s.age) as temp
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Henshall, Stuart - WCP | 2002-02-01 10:15:16 | Re: Difference between Access97 and PostgreSQL |
| Previous Message | D'laila Pereira | 2002-01-31 20:52:42 | test the existence of a database |