select sum(depGZ) as depGZ,sum(productNum) as productNum,depName,
depNamez,depNamed,depNamecj,produceDepCode from #table GROUP BY depName,depNamez,depNamed,
depNamecj,produceDepCode ORDER by cast ( left(produceDepCode,patindex(’%[^0-9]%’,produceDepCode+’,’)-1 ) as int)
produceDepCode 为排序字段名