SELECT
user_phone,
count( * ) AS COUNT
FROM
customer
GROUP BY
user_phone
ORDER BY
COUNT DESC
mysql 统计某一列数据出现的次数
最新推荐文章于 2023-10-27 10:45:24 发布
SELECT
user_phone,
count( * ) AS COUNT
FROM
customer
GROUP BY
user_phone
ORDER BY
COUNT DESC