→ chan15:要用到子查詢喔，感覺有點傷… 05/11 16:10
結構
+-------+------------------+------+-----+---------+----------------+
| 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