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 same session id, with different types and different modification time. I want to get the latest modified record for any given

Re: Simple GROUP / ORDER problem

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

Re: Simple GROUP / ORDER problem

: 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 same session id, with different types and different

Re: Simple GROUP / ORDER problem

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