Re: SQL ? - summing same field, two results

Diane,

I think this should work:

WITH t1
AS (SELECT id, MIN(date1) AS first_date
FROM mylib.test GROUP BY id)
,t2
AS (SELECT id, SUM(money) AS tot_money
FROM mylib.test GROUP BY id)

SELECT t1.id
,(SELECT money FROM mylib.test
WHERE id = t1.id AND date1 = t1.first_date)
AS first_money
,t1.first_date
,t2.tot_money FROM t1 INNER JOIN t2 USING(id)


Be sure to have appropiate indexes by date and id.

HTH,
Luis Rodriguez