PDA

View Full Version : Sorted List



Medyman
02-05-2008, 05:09 AM
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
02-05-2008, 02:49 PM
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.