作者chan15 (ChaN)
看板Database
标题[SQL ] MySQL GROUP 问题
时间Wed May 11 14:52:47 2011
结构
+-------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| name | varchar(20) | YES | | NULL | |
| fk | varchar(20) | YES | | NULL | |
+-------+------------------+------+-----+---------+----------------+
资料
SELECT * FROM gg;
+----+------+------+
| id | name | fk |
+----+------+------+
| 1 | a | aaa |
| 2 | b | aaa |
| 3 | c | bbb |
+----+------+------+
我想要用 fk 做 GROUP 捞出最新的资料
我的语法为
SELECT * FROM gg GROUP BY fk HAVING MAX(id);
结果却是
+----+------+------+
| id | name | fk |
+----+------+------+
| 1 | a | aaa |
| 3 | c | bbb |
+----+------+------+
我想要得是 id = 2 跟 id = 3 的结果
请问该怎麽下才对呢？
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 111.250.4.183
2F：→ chan15:要用到子查询喔，感觉有点伤… 05/11 16:10