Selecting Newest Articles By Unique Authors
Posted: Tue Jan 08, 2008 12:57 am
I am trying to figure out how I can select the most recent articles added to a MySQL table but not repeat any authors.
I have tried this:
But the results will contain repeated authors, which is what I am trying to avoid. Any thoughts...
I have tried this:
Code: Select all
SELECT DISTINCT authorID, articleID, articleTitle FROM articles ORDER BY dateAdded DESC LIMIT 3