按照id排序group by

[littlebirds]

select id,line_name as line from line_pa group by line_name,id

结果类似：
1 b
2 b
3 b
4 a
5 a
6 c
7 c

如何求得结果按照id排序如：
1 b
4 a
6 c

[jamesrggg]

select Max(id) As ID,line_name as line from line_pa group by line_name

[littlebirds]

引用 1 楼 jamesrggg 的回复:

select Max(id) As ID,line_name as line from line_pa group by line_name

不是这样的结果。

[littlebirds]

好像1#写反了，select id,line_name as line from line_pa group by id，line_name

[jamesrggg]

select Min(id) As ID,line_name as line from line_pa group by line_name 刚才弄错了,是取最小值

[littlebirds]

引用 4 楼 jamesrggg 的回复:

select Min(id) As ID,line_name as line from line_pa group by line_name 刚才弄错了,是取最小值

还是不对啊，原查询语句应该是select id,line_name as line from line_pa group by id，line_name

[littlebirds]

select line from (select min(id)ID,line_name as line from line_pa group by line_name)a order by ID 结贴