比如以下语句:
一
select 字段A,count(*) as count from 表A group by 字段A,order by count desc
查询的结果就是。表A中。字段A中重复出现次数最多记录
字段A, count
11 , 10
22 , 7
12 , 1
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
二
select 字段A from 表A group by 字段Aorder by count(字段A) desc
字段A
11
22
12
三。联合查询()
SELECT t.* FROM 表A t LEFT JOIN 表B n on t.字段1= n.字段2 group by n.字段2 order by count(n.字段2) desc Limit 0,50