- 论坛徽章:
- 0
|
本帖最后由 xmi 于 2010-10-17 12:53 编辑
我有一个TABLE LOG内有十几万条RECORD, 我想知它们在00:00:00至23:59:59中间有冇失去连络 多于15分钟. SQL应如何自己做比对呢?
TABLE_LOG
DATE TIME LOCATION MACHINE MESSAGE
15/10/2010 01:00:00 BEJ K001 abc
15/10/2010 01:01:00 BEJ K001 abc
15/10/2010 01:10:00 BEJ K001 abc
15/10/2010 01:40:00 BEJ K001 abc
15/10/2010 01:00:00 KLN K002 abc
15/10/2010 01:01:00 SHH K002 abc
15/10/2010 01:10:00 SHH K002 abc
15/10/2010 01:20:00 SHH K002 abc
15/10/2010 01:21:00 SHH K002 abc
15/10/2010 01:01:00 ZEH H001 abc
15/10/2010 01:30:00 ZEH H001 abc
15/10/2010 01:31:00 ZEH H001 abc
OUTPUT RESUT
DATE TIME LOCATION MACHINE DATE2 TIME2
15/10/2010 01:10:00 BEJ K001 15/10/2010 01:40:00
15/10/2010 01:01:00 ZEH H001 15/10/2010 01:30:00 |
|