You want to have all the records for each user or just the record with the latest datetime for each user ?

>I have the following table:
>
>TL_USER C(25)
>TL_DATE DATETIME
>
>I want to run a single SELECT statement that will group TL_USER but display it in DESCENDING TL_DATE order, so I get the latest DATETIME for each user.
>
>Any ideas?
>I have tried:
>
>SELECT *;
>FROM transferlog;
>GROUP BY tl_user;
>ORDER BY tl_date DESC