“群”是什么意思?
如果要使用GROUP BY,可以执行以下操作:
SELECT
CASE
WHEN
code BETWEEN 5300 AND 5310 OR
code BETWEEN 7100 AND 7200 OR
code BETWEEN 8210 AND 8290
THEN 'Group A'
ELSE 'Group B'
END AS grp,
COUNT(*) AS cnt
FROM your_table
GROUP BY grp
也许您只是想订购?
SELECT
CASE
WHEN
code BETWEEN 5300 AND 5310 OR
code BETWEEN 7100 AND 7200 OR
code BETWEEN 8210 AND 8290
THEN 'Group A'
ELSE 'Group B'
END AS grp,
*
FROM your_table
ORDER BY grp
还要注意BETWEEN包括两个端点,这可能不是您的意思。