Postgres Pro
Downloads
Home   >   mailing lists

select with group by problem - Mailing list pgsql-sql

From Stephan Bauer
Subject select with group by problem
Date
Msg-id 385A3699.36A4E9FF@gmx.de
Whole thread Raw
Responses Re: [SQL] select with group by problem  (<kaiq@realtyideas.com>)
Re: [SQL] select with group by problem  (Vladimir Terziev <vlady@school.digsys.bg>)
List pgsql-sql
Tree view 
Hello,

could anyone tell me why the second select statement returns one row.

regards

Stephan

xtra=> select * from
warenkorb;                                                
cookie|datum|artnr|artnr1|artnr2|artikelname|farbe|groesse|menge|preis
------+-----+-----+------+------+-----------+-----+-------+-----+-----
(0 rows)

xtra=> SELECT artnr, artnr1, artnr2, artikelname, farbe, groesse, SUM(
menge ),preis FROM warenkorb WHERE cookie = 'asdfasdf' GROUP BY artnr, artnr1,
artnr2,artikelname, farbe, groesse, preis;
artnr|artnr1|artnr2|artikelname|farbe|groesse|sum|preis
-----+------+------+-----------+-----+-------+---+-----    |      |      |           |     |       |   |     
(1 row)

pgsql-sql by date:

Previous
From: Margarit Nickolov
Date:
Subject: Re: [SQL] adding time to a datetime field ... how?
Next
From:
Date:
Subject: Re: [SQL] select with group by problem