SELECt SourceId,RecordId,StartDate,EndDate , DATEDIFF(mi,a.EndDate,b.StartDate) DiffMinFROM table aLEFT JOIN table b ON A.no = B.no+1
SELECt SourceId,RecordId,StartDate,EndDate , DATEDIFF(mi,a.EndDate,b.StartDate) DiffMinFROM table aLEFT JOIN table b ON A.no = B.no+1
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
