急求不重复记录的SQL语句~~~

来源：百度知道 编辑：UC知道 时间：2024/05/24 08:20:34
id bumen
1 1
2 1
3 2
4 3
5 2

id字段是信息的自动编号,bumen字段是部门的编号,想按照发布数量从多到少,依次列出部门编号.
各位都试了吗？语句都不行啊~~~

select bumen from table group by bumen having count(*)=1

这是很简单的SQL基本问题,
select ID ,distinct BUMEN FROM 表
-------------------------------
select bumen,count(bumen) from table111

select bumen,count(id) as total from TABLE order by total desc

select bumen,count(bumen) as '数量' from table group by bumen