mysql语句错误,帮忙看一下

yikong 发布于 2015/05/25 17:11
阅读 169
收藏 0
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group by danwei  order by count(*) desc' at line 1
加载中
0
shijacky
shijacky
尼码sql都不发让别人看啥?
0
houhuiliang
houhuiliang
order by count(*) desc ? 这个是什么目的
0
macgroup
macgroup
SELECT danwei,  count(*) AS n FROM table_name GROUP BY danwei  ORDER BY n DESC
返回顶部
顶部