SELECT SUM(Cc.total), SUM(Cc.qtde), Cc.codigo; FROM cur_products as cc; GROUP BY Cc.codigo; ORDER BY 1 DESC, 2 DESCthanks
>>SELECT SUM(qty) as tot_qty, SUM(tot) as sumt, client, codesy, qty, unit, tot, comiss; >> FROM cur_products; >> GROUP BY codesy; >> ORDER BY sumt desc, tot_qty, desc; >> INTO cursor cur_prod_tot >>>>
>SELECT SUM(qty) as tot_qty, SUM(tot) as sumt, client, codesy, unit, comiss; >... >GROUP BY client, codesy, unit, comiss ; > >* if grouping on codesy only > >SELECT SUM(qty) as tot_qty, SUM(tot) as sumt, codesy ; >... >GROUP BY codesy ; > >