Hi All , Please help me with a query where table is in particular format
Visitor_id | page | next page|
I want to the count or list of visitors who visited a particular page (let say X) then visited another page (let say Y)
which functions would be useful
I doubt that you can do that easily with the structure you have. maybe a Recursive CTE would do it ...
We solve that by having a Session No. and DateTime as columns in the Log Table, rather than ThisPage, NextPage, so we can find any Session that has PageX and then, later on in the session, PageY by a simple self-referencing JOIN, or EXISTS, rather than having to follow a linked-list