我要为此创建一个查询:
从我的表[tblTempBlackList]中删除其dateTime字段和dateTime.Now之间的差异超过240分钟的地方。
我尝试了此查询,但没有成功:
DELETE FROM [tblTempBlackList]
WHERE (SELECT DATEDIFF(MINUTE, (SELECT [tblTempBlackList].BlackListDateTime
FROM [tblTempBlackList]
WHERE MobileNumber = '') , GETDATE()
)
) > '240'`
试试这个:
DELETE FROM tblTempBlackList
WHERE
DATEDIFF(MINUTE, (SELECT [tblTempBlackList].BlackListDateTime FROM [tblTempBlackList] WHERE MobileNumber = ''), GETDATE()) > 240
或者,更简洁地说:
DELETE FROM tblTempBlackList
WHERE
DATEDIFF(MINUTE, BlackListDateTime, GetDate()) > 240
AND MobileNumber = ''
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句