Hi folks,
Sorry to ask a newbie SQL question but I'm struggling...
I have a website clickstream log:
request_id session_id sequence_num url
100 xxx 1 /foo
101 xxx 2 /bar
102 xxx 3 /hoo
103 yyy 1 /foo
104 yyy 2 /bar
I need to count the number of times each url was an exit
page. An exit page is the highest sequence_num for each
session_id - 102 & 104 in the example. The report would look
like:
Exit pages:
/foo 4555
/bar 3204
/hoo 2337
etc...
Any pointers would be much appreciated!
------------------
Geoff Caplan
Vario Software Ltd
(+44) 121-515 1154
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
