Re: SQL ? - summing same field, two results

[Luis Rodriguez <luisro58@xxxxxxxxx>]

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