在mysql書寫分段函數的方法
mysql中的分段函數是INTERVAL()函數，sql語句如下：
SELECTINTERVAL (percent, 0, 26, 51),COUNT(1)FROMtestGROUP BYINTERVAL (percent, 0, 26, 51);
SELECT
INTERVAL (percent, 0, 26, 51),
COUNT(1)
FROM
test
GROUP BY
INTERVAL (percent, 0, 26, 51);
