SQL 按出现次数排序

SQL 按出现次数排序
SELECT * FROM table_name
GROUP BY field_name
ORDER BY COUNT(field_name) DESC;

其中table_name和field_name请分别替换为相应的表名和字段名。


2