SELECT
SUBSTRING_INDEX(SUBSTRING_INDEX( , ',', -2), ',', 1) age,
COUNT(*) number
FROM
user_submit
GROUP BY
age;
SQL32 截取出年龄
最新推荐文章于 2024-09-02 07:02:10 发布
SELECT
SUBSTRING_INDEX(SUBSTRING_INDEX( , ',', -2), ',', 1) age,
COUNT(*) number
FROM
user_submit
GROUP BY
age;