- 论坛徽章:
- 0
|
mysql> select * from test;
+------+-------+------+
| id | class | name |
+------+-------+------+
| 1 | AAA | ccc |
| 2 | BBB | mmm |
| 3 | AAA | kkk |
| 4 | AAA | iii |
+------+-------+------+
mysql> select * from test where id in (select id from (select class,min(id) id from test group by class)b);
+------+-------+------+
| id | class | name |
+------+-------+------+
| 1 | AAA | ccc |
| 2 | BBB | mmm |
+------+-------+------+
mysql> select version();
+------------------+
| version() |
+------------------+
| 5.1.32-debug-log |
+------------------+ |
|