表Test,无主键
字段名为:ip,time1,page
Insert TEST Select '11', '2007-10-12 17:31:49', P5
Union All Select '11', '2007-10-12 17:31:23, P3
Union All Select '11', '2007-10-12 17:50:49', P4
Union All Select '12', '2007-10-12 17:31:49', P2
Union All Select '12', '2007-10-12 17:31:50', P9
Union All Select '12', '2007-10-12 17:31:52', P7
Union All Select '13', '2007-10-12 17:31:54', P6
GO中间过程大概结果,根据pageorder对page进行排序,若时间差time1大于10分钟,就另起一行,就如第一与第二次记录
ip,page1,page2,page3,page4
11,p5,null,null,null
11,p3,p4,null,null
12,p2,p9,p7,p6
字段名为:ip,time1,page
Insert TEST Select '11', '2007-10-12 17:31:49', P5
Union All Select '11', '2007-10-12 17:31:23, P3
Union All Select '11', '2007-10-12 17:50:49', P4
Union All Select '12', '2007-10-12 17:31:49', P2
Union All Select '12', '2007-10-12 17:31:50', P9
Union All Select '12', '2007-10-12 17:31:52', P7
Union All Select '13', '2007-10-12 17:31:54', P6
GO中间过程大概结果,根据pageorder对page进行排序,若时间差time1大于10分钟,就另起一行,就如第一与第二次记录
ip,page1,page2,page3,page4
11,p5,null,null,null
11,p3,p4,null,null
12,p2,p9,p7,p6
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货