SELECT DISTINCT
( object_id )
FROM
(
SELECT TOP
100 PERCENT a.*,
b.cnt
FROM
weChat_share a
LEFT JOIN ( SELECT object_id, COUNT ( object_id ) cnt FROM weChat_share WHERE type = 4 GROUP BY object_id ) b ON a.object_id = b.object_id
WHERE
a.type = 4
) c
根据某个字段统计数量并排序(DISTINCT函数会自动排序)
最新推荐文章于 2024-08-11 22:47:23 发布