mysql group by 组内排序
SELECT * FROM (SELECT MAX(id) AS t,wukong_uid, 1 AS tag FROM toutiao_uid_gathered_wukong GROUP BY wukong_uidUNION ALLSELECT id AS t ,wukong_uid, 2 AS tag FROM toutiao_u...
select family,count(*)as familyNum from bold group by family order by familyNum desc
结果:
Emberizidae 739
Anatidae 735
Tyrannidae 635
Parulidae 507
Scolopacidae 399
Muscicapidae 349
Fringil...