От: | hl-man | ||
Дата: | 26.02.08 07:53 | ||
Оценка: |
select count(*) as ccc ,datepart(month , XM_DATE_CREATED) as mmm,datepart(year , XM_DATE_CREATED) as yyy from XT_SHOP_ORDER group by datepart(month , XM_DATE_CREATED),datepart(year , XM_DATE_CREATED) order by yyy,mmm