请问一个关于sql语法group by的问题？
我有一个表其中字段为
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
问题点数：100、回复次数：9Top
1 楼txlicenhe（马可）回复于 2003-09-03 09:57:38 得分 0
select name1 from tablename group by name1
order by min(ID)Top
2 楼nboys（）回复于 2003-09-03 10:04:07 得分 0
select distinct name1 from tablename order by IDTop
3 楼tj_dns（愉快的登山者）回复于 2003-09-03 10:07:20 得分 0
select name1 from table1 group by name1 order by max(ID)
Top
4 楼pengdali（）回复于 2003-09-03 10:08:36 得分 0
select name1 from tablename group by name1 order by min(id)
or
select name1 from tablename group by name1 order by max(id)Top
5 楼CrazyFor（冬眠的鼹鼠）回复于 2003-09-03 10:11:49 得分 0
select min(id) ordcol,name1 from tablename group by name1
order by ordCol
这样好理解些.:)Top
6 楼mjhnet（天涯沦落人）回复于 2003-09-03 10:13:02 得分 0
select name1 from table1 group by name1 order by max(ID)
or
select name1 from table1 group by name1 order by min(ID)
nboys的写法是错误的。Top
7 楼myflok（老虎爱吃肉）回复于 2003-09-03 10:29:08 得分 0
select name1 from table1 group by name1 order by min(ID)
Top
8 楼yyy431706（观兰）回复于 2003-09-03 16:05:24 得分 0
还可以使用这些聚合函数count,sum,avg,不过这里不需要Top
9 楼strongsoft（(沈阳)）回复于 2003-09-17 14:51:05 得分 100
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
Top
