统计表中notices_statellite为不同值的数量,并根据数量进行降序排列
SELECT notices_statellite,count(*) num FROM notices GROUP BY notices_statellite ORDER BY num desc;
结果为:
统计表中notices_statellite为不同值的数量,并根据数量进行降序排列
SELECT notices_statellite,count(*) num FROM notices GROUP BY notices_statellite ORDER BY num desc;
结果为: