检查今天的记录是否已经存在

发布于 2025-02-05 12:08:49 字数 334 浏览 4 评论 0原文

我有一个带有多列的表1如果存在，如果没有，则

我尝试了查询，但似乎很遥远，任何指导都将不胜感激

SELECT DISTINCT(ANI) as mobile
FROM ODCalls
(CallLocalTime)  >= '2022-06-08 00:00:00'
and ANI NOT IN (
    select ANI
    from ODCalls
    WHERE (CallLocalTime)  >= '2022-06-01 00:00:00'
    and (CallLocalTime)  >= '2022-06-07 23:59:59'
)

原文

I have a table with multiple columns where I need to check if the column ANI (ANI is the mobile numbers) called for their first time or they have existing record on the previous dates, I need to return like 1 if exist and 0 if not

I have tried a query but seems to be far away, any guidance will be much appreciated

SELECT DISTINCT(ANI) as mobile
FROM ODCalls
(CallLocalTime)  >= '2022-06-08 00:00:00'
and ANI NOT IN (
    select ANI
    from ODCalls
    WHERE (CallLocalTime)  >= '2022-06-01 00:00:00'
    and (CallLocalTime)  >= '2022-06-07 23:59:59'
)

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

隱形的亼 2025-02-12 12:08:49

SELECT T.ANI AS MOBILE
FROM ODCalls AS T
GROUP BY T.ANI
HAVING MIN(CAST(T.CallLocalTime AS DATE)=CAST(GETDATE()AS DATE)

您可以尝试这样的事情。我不确定有关DateTime可能出现问题的示例数据。该查询应检测到今天已经打了第一个电话的手机。

SELECT T.ANI AS MOBILE
FROM ODCalls AS T
GROUP BY T.ANI
HAVING MIN(CAST(T.CallLocalTime AS DATE)=CAST(GETDATE()AS DATE)

You can try something like this. I am not completely sure with out sample data about possible issues with datetime. This query should detect mobile phones, which have made the first call today.

回复收藏 0 原文

~没有更多了~