1. 分段统计,适用于mysql
SELECT CASE WHEN (POINT >=10 AND POINT <=100) THEN '10-100' WHEN (POINT >=100 AND POINT <=200) THEN '100-200' ELSE '--' END 'end', COUNT(*) COUNT FROM table_name
GROUP BY
CASE WHEN (POINT >=10 AND POINT <=100) THEN '10-100' WHEN (POINT >=100 AND POINT <=200) THEN '100-200' ELSE '--' END
2. 添加“是否”标识
SELECT a.field1,b.field2, CASE WHEN a.field3=b.field4 THEN 'Y' ELSE 'N' END
FROM table_a a , table_b b
WHERE a.aid=b.bid