oracle 手机通话记录数据显示

 

手机通话记录显示方式：

模拟的字段表结构

 

老式手机的显示方式，即通话记录最原始状态：

 

 

代码如下

 With Ate As(
 Select Row_Number() Over(Order By Time Desc) Rn,
        Relatedmobilde,
        Calltype,
        Time
     From Call c Where Targetmobile = 12)
 
 Select Rn, Relatedmobilde, Calltype, Time
   From Ate Where Rn = 1
 Union
 Select b.Rn, b.Relatedmobilde, b.Calltype, b.Time
   From Ate a, Ate b
     Where a.Rn = b.Rn - 1 And a. Relatedmobilde <> b. Relatedmobilde
      Order By Time Desc