有一张app端页面访问表(app_page_view)，结构

select b.m_id,b.path_seq as path_seq,a.page_url as from_url,b.page_url as to_url
from (select m_id,page_url,Row_number() over(partition by m_id order by visit_time) as path_seq from app_page_view) a
right join (select m_id,page_url,Row_number() over(partition by m_id order by visit_time) as path_seq from app_page_view)b on a.m_id=b.m_id and b.path_seq=a.path_seq+1;

Select

a.m_id,a.path_dql,b.page_url from_url,a.page_url  to_url

From (

Select

M_id,

Page_url,

Visit_time,

Row_number() over(partition by m_id order by visit_time as ) as path_seq

From app_page_view ) a

Left outer join

(

Select

M_id,

Page_url,

Visit_time,

Row_number() over(partition by m_id order by visit_time as ) as path_seq

From app_page_view ) b on a.path_seq = b.path_deq + 1  and a.m_id = b.m_id