现在有一个表，其中有两个字段：一个是department，一个是number，department是可以重复的字符型字段，number是唯一的数值型字段，现在我想检索出按照number排序的department的唯一值集合，写了如下一个SQL语句：
select distinct department from bly_deptaddr order by number asc
但执行后SQL Server报错，提示：
ORDER BY items must appear in the select list if SELECT DISTINCT is specified.
请问这个语句该怎么写？谢谢！！！！！！！！！！！！！！
---------------------------------------------------------------
select department from bly_deptaddr group by department
order by min(number) asc
---------------------------------------------------------------
错误提示的意思是：你没有选择number列。
改成如下即可：
select distinct department，number from bly_deptaddr order by number asc