请问一个关于sql语法group by的问题？

[zqhero]

我有一个表其中字段为
ID name1 name2
1.1 a a
1.2 a b
1.3 a c
2.1 c a
2.2 c b
2.3 c c
3.1 b a
.....


问题是要按name1进行分组group by并按ID进行排序
结果我要的是
name1
a
c
b
但是怎么才能按ID排序呢？
我写的语句是select name1 from tablename group by name1
而这句的结果是
name1
a
b
c

[yyy431706]

还可以使用这些聚合函数count,sum,avg,不过这里不需要

[txlicenhe]

select name1 from tablename group by name1
order by min(ID)

[nboys]

select distinct name1 from tablename order by ID

[愉快的登山者]

select name1 from table1 group by name1 order by max(ID)

[pengdali]

select name1 from tablename group by name1 order by min(id)

or

select name1 from tablename group by name1 order by max(id)

[CrazyFor]

select min(id) ordcol,name1 from tablename group by name1
order by ordCol


这样好理解些.:)

[mjhnet]

select name1 from table1 group by name1 order by max(ID)
or
select name1 from table1 group by name1 order by min(ID)

nboys的写法是错误的。

[dafu71]

select name1 from table1 group by name1 order by min(ID)

[strongsoft]

select name1 from table1 group by name1 order by max(ID)
or
select name1 from table1 group by name1 order by min(ID)

select min(id) ordcol,name1 from tablename group by name1
order by ordCol