Could it be that the first query is using max which will only return the max
for b.lot and b.price..
so maybe.
select sum(max(b.lot))as quantity, max(b.price) as price from bid b, person
p where b.auction_id = 84 and p.id = b.person_id ;
Just a thought.
-----Original Message-----
From: pgsql-sql-owner@hub.org [mailto:pgsql-sql-owner@hub.org]On Behalf
Of Louis-David Mitterrand
Sent: Tuesday, September 19, 2000 3:59 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] sum of agreggates in one SELECT?
Hello,
I have the following query/result:
auction=# select max(b.lot) as quantity,max(b.price) as price,p.login from
bid b, person p where b.auction_id = 84 and p.id = b.person_id group by
p.login order by max(price);quantity | price | login
----------+-------+----------- 1 | 5000 | papy 12 | 5750 | cunctator 8 | 6000 | vindex
(3 rows)
Now I would like to sum() all results from the quantity column and
return it with one SELECT statement. Is that possible?
I am trying:
auction=# select sum(b.lot) from bid b, person p where b.auction_id = 84 and
p.id = b.person_id ;sum
----- 52
(1 row)
But this is wrong because it sums all quantities. I don't know how to
apply a valid WHERE clause in that case.
Thanks in advance for any help, cheers,
--
Louis-David Mitterrand - ldm@apartia.org - http://www.apartia.org