Re: [pgbr-geral] REF: DISTINCT E COUNT().

Tue, 02 Apr 2013 09:46:18 -0700 

Tentativa e erro ...

  SELECT
         min(idlista) AS idlista
       , produto
       , sum(qtde1)   AS qtde1
       , sum(qtde2)   AS qtde2
    FROM lista
GROUP BY produto
ORDER BY 1 ASC;

-- ou se a chave for concatenada

  SELECT
         idlista
       , produto
       , sum(qtde1)   AS qtde1
       , sum(qtde2)   AS qtde2
    FROM lista
GROUP BY idlista
       , produto
ORDER BY 1 ASC;
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a