Putting it simply, I want the last record from the group, not the default first. Cheers -- Dave
----- Original Message ----- From: "David Scott" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 08, 2004 11:52 PM Subject: Reversing the group... OK, here is a problem that has been bugging me for some time. If I have a table like this, showing 3 visitors to a website and the pages they view.... id visitorID pageID 1 1 3 2 1 4 3 1 2 4 2 3 5 2 4 6 3 2 7 3 4 so to get the count for each entry page to the site I would do: SELECT pageid, count(pageID) as 'count' FROM hits GROUP BY visitorid ORDER BY 'count' DESC pageid count 3 2 2 1 so page 3 has been the first page people visit 2 times and page 2 has been the first page once. BUT how do I get the last page they have visited? a sort of reverse GROUP BY??? Which would return... pageid count 4 2 2 1 Please Help its driving me nuts :S -- Dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
