Mysql按照字段的重复数排序

select source_job_number,count(*) as count from v1_user WHERE source_id=3 group by source_job_number ORDER BY count DESC;
posted @ 2019-08-29 11:27  离岸少年  阅读(1868)  评论(0编辑  收藏  举报