![](https://static.youtibao.com/asksite/comm/h5/images/m_q_title.png)
在第57题的“文章”表中,显示各个栏目的文章数量,并按数量降序显示,下列SQL语句正确的是()
A.SELECT栏目, COUNT(*) FROM文章 GROUP BY栏目 ORDER BY COUNT(*)
B.SELECT栏目, COUNT(*) FROM文章 GROUP BY栏目 ORDER BY COUNT(*) DESC
C.SELECT栏目,SUM(*) FROM文章 GROUP BY栏目 ORDER BY SUM(*)
D.SELECT栏目,SUM(*) FROM文章 GROUP BY栏目 ORDER BY SUM(*) DESC
![](https://static.youtibao.com/asksite/comm/h5/images/m_q_a.png)
B、SELECT栏目, COUNT(*) FROM文章 GROUP BY栏目 ORDER BY COUNT(*) DESC
![](https://static.youtibao.com/asksite/comm/h5/images/solist_ts.png)