Re: SQL Question, Aggregate and nonAggregate fields..

On Wed, 08 Jul 1998 11:17:57 -0700, John Windberg <jonwa@imaginemedia.com> wrote: >select max(publish_date), series_id from dtv_articles group by series_id >order by series_id; > >I get exactly what I want, but not the article_id. select max(a.publish_date), a.series_id, (select b.article_id from dtv_articles b where a.publish_date=b.publish_date and a.series_id=b.series_id) from dtv_articles a group by 2,3 just hope you don't have two of the same series published on the same date. In which case you might consider selecting the max(article_id) which in your case may or may not necessarily be the record with the max(publish_date). Hope that helps, Douglas Wilson