General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only