评论会员:游客 时间:2012/02/07
这里是:codeprelang="SQL"spanclass="code-keyword"select/span*spanclass="code-keyword"from/spantblactivityspanclass="code-keyword"where/spancheckintime>DATEADD(HOUR,-2,GETDATE())/pre/code好运
KARTHIK Harve
评论会员:游客 时间:2012/02/07
试用这个查询...{C}希望它可以帮助...|koolprasad2003:检查下面的查询codeprelang="SQL"spanclass="code-keyword"SELECT/span*spanclass="code-keyword"FROM/spantblactivityspanclass="code-keyword"WHERE/spancheckintimespanclass="code-keyword"BETWEEN/spanDATE_SUB(NOW(),INTERVALspanclass="code-digit"2/spanHOUR)/pre/code的