select name1 from table1 group by name1 order by max(ID)
select name1 from tablename group by name1 order by min(id)orselect name1 from tablename group by name1 order by max(id)
select min(id) ordcol,name1 from tablename group by name1 order by ordCol 这样好理解些.:)
select name1 from table1 group by name1 order by max(ID) or select name1 from table1 group by name1 order by min(ID)nboys的写法是错误的。
select name1 from table1 group by name1 order by min(ID)
还可以使用这些聚合函数count,sum,avg,不过这里不需要
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
order by ordCol
这样好理解些.:)
or
select name1 from table1 group by name1 order by min(ID)nboys的写法是错误的。
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