| Welcome to WebmasterWorld Guest from 126.96.36.199 |
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
|Subscribe to WebmasterWorld|
|Query to return row with max value|
Anyone know this off the top of their head?
| 10:31 pm on Oct 15, 2005 (gmt 0)|
COLUMNS visitor_id (VARCHAR), page_title (VARCHAR), visit_time (INT)
For a given visitor_id, I need to know the maximum visit_time and the page_title associated with it. Actually, I need a rowset with that data for each unique visitor_id.
Seems like this should have been easy, but it has stumped me.
| 3:01 am on Oct 16, 2005 (gmt 0)|
If I understand the question:
SELECT page_title, MAX(visit_time)
GROUP BY visitor_id
| 4:04 am on Oct 16, 2005 (gmt 0)|
I knew it was easy. I hate SQL.
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
© Webmaster World 1996-2014 all rights reserved