摘要：
表内容如下 ----------------------------- ID LogTime 1 2008/10/10 10:00:00 1 2008/10/10 10:03:00 1 2008/10/10 10:09:00 2 2008/10/10 10:10:00 2 2008/10/10 10:11:00 -----------------------------如何查询登陆时间间隔不超过５分钟的所有记录CREATETABLE#t(idINT,LogTimeDATETIME)INSERTINTO#tSELECT1,'2008/10/1010:00:00'UNIONSELE 阅读全文
摘要：
有表TestCREATETABLEtest(datedatetime,type1VARCHAR(2),type2VARCHAR(2),account1INT,account2INT)-----------------------------------datetype1type2account1account22010-02-21A1B112142010-02-21A1B212192010-02-21A1B114192010-02-21A2B315122010-02-21A2B117142010-02-21A3B218142010-02-21A2B11211一条语句查询出----------- 阅读全文
