On 9/1/05, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > CREATE TABLE t1(a INTEGER, b INTEGER, c INTEGER); > INSERT INTO t1 VALUES(1,2,1); > INSERT INTO t1 VALUES(NULL,2,2); > INSERT INTO t1 VALUES(1,NULL,4); > INSERT INTO t1 VALUES(NULL,NULL,8); > INSERT INTO t1 SELECT * FROM t1; > SELECT a, b, sum(c) FROM t1 GROUP BY a, b ORDER BY 3;
Postgres 8.0.3 and Firebird 1.5.2: a |b |sum 1 |2 |2 NULL|2 |4 1 |NULL|8 NULL|NULL|16 -- Nemanja Corlija <[EMAIL PROTECTED]>
