[RESOLVED] Help with GROUP BY or DISTINCT

[sidsel]

I have a query like the one below but it doesn't work as expected.

select profile_id, header, blog_id, max(publish_date) from blog group by profile_id

header, blog_id contains data from the first row it meets, not the newest row as I am trying to select with MAX.

Any hints?

[Lars_Berg]

select profile_id, header, blog_id,publish_date
  from blog as b
 where publish_date in
    (select max(publish_date)
        from blog
       where blog.profile_id = b.profile_id)