SELECT question

[steijssen]

Hello,

I have a table "items" like this:

id
item
section
posting_date

Now what I want to do is to make a SELECT query that retrieves the 3 newest "items" for this table, but none of them should belong to the same "section". How do I do this?

Until now I have:
SELECT * FROM items GROUP BY posting_date DESC LIMIT 3

Thanks for your time!!

 

[LittleSmudge]

Well first off you need

SELECT * FROM items ORDER BY posting_date DESC LIMIT 3

Order By rather than Group By


getting the 3 to have unique Section values will take a bit more thinking about




G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[LittleSmudge]

How about

SELECT * 
FROM items As i1 
ORDER BY posting_date DESC LIMIT 1

UNION

SELECT * 
FROM items As i2 
WHERE Section NOT IN ( i1.Section ) 
ORDER BY posting_date DESC LIMIT 1

UNION

SELECT * 
FROM items As i3
WHERE Section NOT IN ( i1.Section, i2.Section )
ORDER BY posting_date DESC LIMIT 1

'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[steijssen]

Seems logical, but I get an error "Incorrect use of Union and Order by"...