select redux

[thoand]

How can I print out the LATEST from each priority (1-5), in one select?

eg. the latest priority 1, the latest priority 2, the latest priority 3 ...,

The table:

title (a title)
priority (having values 1-5)
created (datetime)

the html should then look like

Title 1 | 1 | 2002-08-19 15:08:08
Title 2 | 2 | 2002-08-19 15:07:08
Title 3 | 3 | 2002-08-19 15:06:08
Title 4 | 4 | 2002-08-19 15:09:08
Title 5 | 5 | 2002-08-19 15:12:08

[tomhath]

select title, priority, max(created)
from theTable
group by title, priority
order by title, priority