取出不重复记录，排序问题

[taito]

如这样一个表 [AUser]

Id Name

select distinct name from AUser

我想按 Id 排序

select distinct name from AUser order by Id

这样写就会出错。应该怎样得到正确结果呢？

[fcuandy]

SELECT MIN(ID) /*或MAX(ID)*/ ,Name FROM Auser GROUP BY Name ORDER BY MIN(ID) /*或MAX(ID)*/

依你具体情况而定

[九斤半]

如果是一个ID对应一个NAME

select name
from
(
select distinct ID,name from AUser order by Id
)A

[playwarcraft]

select min(id),[name] from Auser group by [name] order by min([id])