急急急,, group by

Question

表结构,如下
+------------+-----------+-------+----------------+---------------------+
| comment_id | member_id | cd_id | title          | insert_time         |
+------------+-----------+-------+----------------+---------------------+
|          1 |     10003 |     6 | 好听,太好听了  | 2006-12-17 18:49:47 |
|          2 |     10003 |     6 | 再发           | 2006-12-17 19:16:46 |
|          3 |     10003 |     6 | v              | 2006-12-17 19:18:42 |
|          4 |     10003 |     6 | 发             | 2006-12-17 19:20:43 |
|          5 |     10003 |     6 | what           | 2006-12-17 19:52:20 |
|          6 |     10003 |     6 | 自己的...      | 2006-12-17 21:21:03 |
|          7 |     10003 |     5 | 昨夜长风       | 2006-12-18 00:16:49 |
|          8 |     10003 |     5 | 说不笑还笑     | 2006-12-18 01:56:03 |
|          9 |     10003 |     5 | 谁说的~~       | 2006-12-18 01:57:59 |
|         10 |     10003 |     6 | 有啥??         | 2006-12-18 02:52:39 |
|         11 |     10003 |     5 | Oo。冬天结冰了 | 2006-12-18 02:59:36 |
|         12 |     10003 |     6 | 少啊~~~        | 2006-12-18 03:11:43 |
|         13 |     10003 |     5 | 三千字         | 2006-12-18 18:44:57 |
|         14 |     10003 |     5 | 1111111        | 2006-12-19 17:23:06 |
|         15 |     10003 |     5 | 新测试         | 2006-12-20 00:44:54 |
|         16 |     10003 |     5 | 再新           | 2006-12-20 01:11:49 |
|         17 |     10003 |     5 | 新测试         | 2006-12-20 01:15:19 |
+------------+-----------+-------+----------------+---------------------+希望 group by 出下面的结果,,就是 时间最新的,不同的 cd_id 的结果+------------+-----------+-------+---------------+---------------------+
| comment_id | member_id | cd_id | title         | max(insert_time)    |
+------------+-----------+-------+---------------+---------------------+
|          7 |     10003 |     5 | 新测试        | 2006-12-20 01:15:19 |
|          1 |     10003 |     6 | 有啥??        | 2006-12-18 03:11:43 |
+------------+-----------+-------+---------------+---------------------+

Answer 1

select comment_id,member_id,cd_id,title,max(insert_time)
from table
where...
group by cd_id

Answer 2

不灵,,,主要是 title 的内容要和 max(insert_time)匹配...大家加油,,,OK的话...3秒就结帖...
我这边使用的是 mysql5.11

Answer 3

to defty()
刷出来是这样子的.+------------+-----------+-------+---------------+---------------------+
| comment_id | member_id | cd_id | title         | max(insert_time)    |
+------------+-----------+-------+---------------+---------------------+
|          7 |     10003 |     5 | 昨夜长风      | 2006-12-20 01:15:19 |
|          1 |     10003 |     6 | 好听,太好听了 | 2006-12-18 03:11:43 |
+------------+-----------+-------+---------------+---------------------+

Answer 4

select *
from 表 a
where insert_time = (select max(insert_time) from 表 where member_id=a.member_id
                                               and cd_id=a.cd_id);

Answer 5

select comment_id,member_id,cd_id,title,max(insert_time)
from a,b where a.cd_id = b.cd_id
group by cd_id

Answer 6

to All正解如下:)SELECT comment_id,member_id,cd_id,title,insert_time FROM tb_a WHERE comment_id IN (SELECT max(insert_time) FROM tb_a WHERE member_id = '10003' GROUP BY cd_id) ORDER BY insert_time DESC ;