mysql - 如何使用最大值进行分组

Question

我有一个看起来像这样的查询:

SELECT max(insert_date),
       creative_id,
       creative_object
FROM   rtb_creatives
WHERE  adgroup_id = 'agid1608844879'
       AND is_delete IN ( 0 )
GROUP  BY insert_date,
          creative_id,
          creative_object 

例如我有 4 行:insert_date creative_id, creative_object

 june 12 a b
 june13 a b
 june 12 c d
 june13 c d

查询正在返回所有行。

我要回去

june13 a b
 june13 c d

如何修改查询？

Answer 1

只需从 GROUP BY 子句中删除 insert_date:

SELECT max(insert_date) AS insert_date, creative_id, creative_object
from rtb_creatives 
where adgroup_id='agid1608844879' and is_delete in (0)
group by creative_id, creative_object