且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何检查特定列的21天值是否相同,如果为true,则设置标志?

更新时间:2023-09-18 19:22:52

萨拉斯,

   您可以使用 滑动窗口.如果您需要一个示例,页面底部也提供了一个类似的示例.您需要更改的只是添加具有指定条件的WHERE子句,更改SlidingWindow(day,21)和HAVING COUNT(*)= 21.

   You could use sliding window for this. If you want an example, there is also a similar example provided at the bottom of the page. All you have to change is add WHERE clause with the condition you specified to it, change SlidingWindow(day, 21) and HAVING COUNT(*) = 21.

如有任何疑问,请告诉我

Please let me know, if you have any questions

--------------------------------------------------- -------------------------------------------------- --------------

---------------------------------------------------------------------------------------------------------------

请点击标记为答案"如果您认为答案有用

Please click "Mark as Answer" if you find the answer useful