先上表结构
要求根据artist_id统计数量并排序
SELECT artist_id,count(artist_id) num FROM test GROUP BY artist_id ORDER BY count(artist_id) desc;
结果
先上表结构
要求根据artist_id统计数量并排序
SELECT artist_id,count(artist_id) num FROM test GROUP BY artist_id ORDER BY count(artist_id) desc;
结果