我想获得为特定服务激活的用户列表，但是过去几年dint再次被重新激活，请你给出逻辑... [英] I want to get the list of users who are activiated for particular service but dint get reactivated again in past years can you please give the logic ...

问题描述

我想从表中获取特定服务激活的用户列表但过去几年再次重新激活dint你能不能给出逻辑...





喜欢activation_status = 0的东西...... ??

I want to get the list of users from a table who are activiated for particular service but dint get reactivated again in past years can you please give the logic ...


like activation_status = 0 something ... ??

推荐答案

尝试：

Try:

... WHERE activation_status = 0 AND
activation_date < DATEADD(y, -1, GETDATE())

这篇关于我想获得为特定服务激活的用户列表，但是过去几年dint再次被重新激活，请你给出逻辑...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！