SELECT CASE LEFT(num, 1) WHEN '0' THEN 0 ELSE 1 END, SUM([sum])
FROM yourTable
GROUP BY CASE LEFT(num, 1) WHEN '0' THEN 0 ELSE 1 END
FROM yourTable
GROUP BY CASE LEFT(num, 1) WHEN '0' THEN 0 ELSE 1 END
GROUP BY CASE LEFT(num, 1) WHEN '0' THEN 0 ELSE 1 END
根据num字段第一个字母是否为0分成2组,对sum字段再求和。
FROM yourTable
GROUP BY CASE LEFT(num, 1) WHEN '0' THEN 0 ELSE 1 END