"Lee Denny" <[EMAIL PROTECTED]> wrote on 06/29/2005 08:00:49 AM:
> Hello,
>
> If got a simple sessions table basically holds a session id and datetime
> field for last modification also a session type, so I can have several
> records with the same session id, with different types and different
>
CTED]>
To:
Sent: Wednesday, June 29, 2005 8:00 AM
Subject: Simple GROUP / ORDER problem
> Hello,
>
> If got a simple sessions table basically holds a session id and datetime
> field for last modification also a session type, so I can have several
> records with the
Try adding max(session_modified).
SELECT *,max(session_modified) AS LastMod FROM translines GROUP BY
session_id ORDER BY session_modified DESC
On Jun 29, 2005, at 8:00 AM, Lee Denny wrote:
Hello,
If got a simple sessions table basically holds a session id and
datetime
field for last modif
Hello,
If got a simple sessions table basically holds a session id and datetime
field for last modification also a session type, so I can have several
records with the same session id, with different types and different
modification time. I want to get the latest modified record for any given
sess
