https://blog.youkuaiyun.com/m0_52607906zh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/m0_52607906/article/details/150611268https://blog.youkuaiyun.com/m0_52607906/article/details/150611268m0_52607906Fri, 22 Aug 2025 15:15:14 +0800https://blog.youkuaiyun.com/m0_52607906/article/details/150611153https://blog.youkuaiyun.com/m0_52607906/article/details/150611153m0_52607906Fri, 22 Aug 2025 15:10:41 +0800https://blog.youkuaiyun.com/m0_52607906/article/details/145595351https://blog.youkuaiyun.com/m0_52607906/article/details/145595351m0_52607906Wed, 12 Feb 2025 16:31:58 +08001，反而忘了group by怎么解题了。判断是否连续出现3次：选定窗口大小为当前窗口-1 +1，得到窗口里的max、min，若max=min则说明三个数一样，即连续。需要考虑边界值：用id判断，id<>1 and id<> n（总行数：用count*得到）错误原因：搞混“空”和“NULL”了。]]>https://blog.youkuaiyun.com/m0_52607906/article/details/145560795https://blog.youkuaiyun.com/m0_52607906/article/details/145560795m0_52607906Tue, 11 Feb 2025 00:09:27 +0800https://blog.youkuaiyun.com/m0_52607906/article/details/136823265https://blog.youkuaiyun.com/m0_52607906/article/details/136823265m0_52607906Mon, 18 Mar 2024 21:55:58 +0800https://blog.youkuaiyun.com/m0_52607906/article/details/123059476https://blog.youkuaiyun.com/m0_52607906/article/details/123059476m0_52607906Tue, 22 Feb 2022 01:19:37 +0800https://blog.youkuaiyun.com/m0_52607906/article/details/121590945https://blog.youkuaiyun.com/m0_52607906/article/details/121590945m0_52607906Sun, 28 Nov 2021 14:26:10 +0800