查询sql为:
SELECT
device_id,
count( device_id ) AS number
FROM
cms_sticker_member
GROUP BY
device_id
HAVING
count( device_id ) >= 1
ORDER BY
number DESC;
结果:
查询sql为:
SELECT
device_id,
count( device_id ) AS number
FROM
cms_sticker_member
GROUP BY
device_id
HAVING
count( device_id ) >= 1
ORDER BY
number DESC;
结果: