I have a table like (mysql):
table(ID, URL, Date, IP )
How can I find the most popular first/last URL viewed pr IP pr day.
That is I have problems when I use the GROUP BY.
Its easy to find the latest page viewed ever.
SELECT URL FROM table ORDER BY Date ASC.
If I try something like
SELECT URL FROM table GROUP BY Date, IP ORDER BY Date ASC
The ORDER BY is done after the group by and I need to order before the group by so that I can get the last/first page pr user pr day.
Any sugestions?
