随笔分类 -  SQL使用基础

SQL查询所选数据中相邻两行的时间相减
摘要：with t as (select OID,time,ROW_NUMBER() over (order by OID) rnfrom shengchan twhere time> '2016-08-25'and deviceID= 18 )select sc.OID,sc.time,t.OID,t. 阅读全文
posted @ 2016-08-29 14:29 我要吃肉 阅读(4050) 评论(0) 推荐(0)