group by 居然有 order by 效果

mysqlkumao

今天才知道 group by 居然有 order by 效果，也可以用 asc 和 desc 关键字

mysql> select * from abc;

+----+------+
| c1 | c2   |
+----+------+
|  1 |  5.2 |
|  2 |  2.5 |
|  3 |  7.8 |
|  4 | 5.69 |
|  5 | 4.05 |
+----+------+
5 rows in set (0.00 sec)

mysql> select * from abc group by c2;

+----+------+
| c1 | c2   |
+----+------+
|  2 |  2.5 |
|  5 | 4.05 |
|  1 |  5.2 |
|  4 | 5.69 |
|  3 |  7.8 |
+----+------+
5 rows in set (0.00 sec)

[ 本帖最后由 mysqlkumao 于 2008-2-11 17:06 编辑 ]