Sorted List

[Medyman]

Hey guys,

If I have a two column database table, with one column having repetitive values, how would I query the table to present a list sorted by date like such:

Let's say the columns are date and message (with date being repeated):

Distict date
All messages from that date

Next distinct date
all messages from this date

[james438]

I'm confused. Wouldn't something like:

select * from tablename order by date desc

work as well as a few other variations of said code? or are you wanting to do something different? I'm just saying I'm not sure what you are asking.