select with group by problem

Поиск
Список
Период
Сортировка
От Stephan Bauer
Тема select with group by problem
Дата
Msg-id 385A3699.36A4E9FF@gmx.de
обсуждение
Ответы Re: [SQL] select with group by problem
Re: [SQL] select with group by problem
Список pgsql-sql
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 по дате отправления: