+ -
当前位置:首页 → 问答吧 → Sybase与Oracle SQL语句问题,请各位大虾指点,“散分啊”

Sybase与Oracle SQL语句问题,请各位大虾指点,“散分啊”

时间:2011-11-15

来源:互联网

要求:需要查询出表中间隔时间在5分钟内的数据
  一张表:
  1,"2008-09-09 00:02:00"
  2,"2008-09-09 00:02:00"
  3,"2008-09-09 00:02:05"
  4,"2008-09-09 00:03:00"
  5,"2008-09-09 00:04:00"
  6,"2008-09-09 00:05:00"
  7,"2008-09-09 00:05:05"
  预期结果:
  1,"2008-09-09 00:02:00"
  2,"2008-09-09 00:02:00"
  3,"2008-09-09 00:02:05"
  6,"2008-09-09 00:05:00"
  7,"2008-09-09 00:05:05"
请大虾指点需要用Sybase与Oracle SQL语句得到如上结果。

作者: yygywqf   发布时间: 2011-11-15

知道怎么写了:
SQL code

select * from [tb] a
where exists(select 1 from tb where id<>a.id and abs(datediff(mi,time,a.time))<=5)


作者: yygywqf   发布时间: 2011-11-15

SQL code

select m.* from tb m , tb n where m.id = n.id - 1 and datediff(mi , m.time , n.time) <= 5

select m.* from tb m , tb n where m.id = n.id - 1 and abs(datediff(mi , m.time , n.time) <= 5)

select m.* from tb m where datediff(mi , m.time , (select top 1 time from tb n where n.time > m.time order by time desc)) <= 5




作者: yygywqf   发布时间: 2011-11-15

哦.恭喜.

作者: dawugui   发布时间: 2011-11-16

热门下载

更多