[SQL ] MySQL GROUP 問題
結構
+-------+------------------+------+-----+---------+----------------+
| 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
推
05/11 15:12, , 1F
05/11 15:12, 1F
→
05/11 16:10, , 2F
05/11 16:10, 2F