在SQL查询中同时使用DISTINCT和ORDER BY
SELECT DISTINCT sbzrbm, sybm
FROM clsbtz
WHERE sbzrbm IS NOT NULL
GROUP BY sbzrbm
ORDER BY (CASE sbzrbm WHEN '一车间' THEN 1 WHEN '二车间' THEN 2 WHEN
'三车间' THEN 3 WHEN '四车间' THEN 4 WHEN '五车间' THEN
5 END)
SQL查询中能够同时使用DISTINCT和ORDER BY