| From: | Chris Bitmead <chris(dot)bitmead(at)bigfoot(dot)com> |
|---|---|
| To: | pgsql-sql(at)hub(dot)org |
| Subject: | Slashdot Query |
| Date: | 1999-06-04 03:18:53 |
| Message-ID: | 3757459C.F0E63B5E@bigfoot.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
I want to do a query that is like the icons on the top of
http://slashdot.org. That is I want to select the 5 most recent distinct
categories from a bunch of stories. So I have...
SELECT DISTINCT category.oid, category.title, category.image FROM story,
category* WHERE story.category = category.oid AND story.approved ORDER
BY datetime DESC LIMIT 5;
The trouble is it doesn't return distinct results, but rather it returns
duplicates. Any ideas how I can do this query?
I thought there might be some sub-select solution, but I don't really
understand subselects. I thought of,
SELECT distinct * from (SELECT category.oid, category.title,
category.image FROM story, category* WHERE story.category = category.oid
AND story.approved ORDER BY datetime DESC )LIMIT 5;
But that doesn't work in any shape or form.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | nathan | 1999-06-04 05:17:23 | Embedded SQL in 'C' |
| Previous Message | Tim Perdue | 1999-06-04 01:47:30 | Group By Dilemma |