How to do a group by clause with a max

Question

I have a query that looks like thos :

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 

E.g. I have 4 rows: insert_date creative_id, creative_object

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

The query is returning all rows.

I need to return

june13 a b
 june13 c d

How do I modify the query?

Answer 1

Just remove the insert_date from the GROUP BY clause:

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