Here is a sample of three rows from my table, all from AuthorID 89:
Code: Select all
ID |AuthorID| Headline | Subject | URL | DatePublished
--------+--------+-------------------+-----------+--------------------------+--------------
1008 | 89 | Sample Headline 1 | Politics | http://www.example.com/1 | 2009-04-16
735 | 89 | Sample Headline 2 | Politics | http://www.example.com/2 | 2009-04-15
730 | 89 | Sample Headline 3 | Politics | http://www.example.com/3 | 2009-04-13
651 | 89 | Something Else | Economics | http://www.example.com/4 | 2009-03-26Code: Select all
SELECT Headline, Subject, URL, DatePublished
FROM Articles
WHERE AuthorID = 89
GROUP BY Subject
ORDER BY DatePublished DESCCode: Select all
Headline | Subject | URL | DatePublished
-------------------+-----------+--------------------------+--------------
Sample Headline 3 | Politics | http://www.example.com/3 | 2009-04-13
Something Else | Economics | http://www.example.com/4 | 2009-03-26This is what I would like the results to look like:
Code: Select all
Headline | Subject | URL | DatePublished
-------------------+-----------+--------------------------+--------------
Sample Headline 1 | Politics | http://www.example.com/1 | 2009-04-16
Something Else | Economics | http://www.example.com/4 | 2009-03-26I've wasted a lot of time on this, and feel like there must be a simple solution. Can someone please help me out?