Re: Help with ordering and grouping with distinct ...

2002-09-23 Thread gerald_clark
ORDER BY SentDate DESC Ben Holness wrote: >Hi all, > >I have a table with three columns: > >Destinationvarchar(254) >SentDate timestamp(14) >UserID varchar(32) > >I want to be able to get a list of the 100 most recently used numbers, based >on the timestamp (Sen

Help with ordering and grouping with distinct ...

2002-09-21 Thread Ben Holness
Hi all, I have a table with three columns: Destination varchar(254) SentDatetimestamp(14) UserID varchar(32) I want to be able to get a list of the 100 most recently used numbers, based on the timestamp (SentDate) column. I want to have them ordered such th