group by

[Dmitry Lendel]

ðÒÉ×ÅÔ.
éÇÒÁÀÓØ Ó ÁÇÒÅÇÁÔÁÍÉ. ðÏÑ×ÉÌÁÓØ ÍÙÓÌØ, ÐÏÒÑÄÏË ÕËÁÚÁÎÉÑ ÐÏÌÅÊ × group by
ÉÍÅÅÔ ËÁËÏÊ-ÔÏ ÓÍÙÓÌ?

Select idkey,
          idparent,
          Sum(Quantity) as Quantity
from MyTable
group by 1,2

Select idkey,
          idparent,
          Sum(Quantity) as Quantity
from MyTable
group by 2,1

âÕÄÅÔ ÒÁÚÎÙÊ ÒÅÚÕÌØÔÁÔ?
äÍÉÔÒÉÊ