Hi there. I would like to return the 2 most recent events from my table,
for each author (Author_ID). Here's my table structure (simplified).
Is there a way to do this with a query instead of getting every record,
sorted by Author_ID, displaying the first two events, and skipping through
until the Author_ID changes, then displaying the first 2 events for that
I know I could use a GROUP BY clause, but can I limit the number of records
returned in each group, sorted by date?
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php