SQL Windows Functions might be non-deterministic
- Chen Hirsh
- Oct 1, 2024
- 1 min read
One of the scariest things that can happen when you develop SQL code is getting indeterminate results. When you run your query multiple times and each time gets a different value.
Using SQL Windows functions with non-unique order columns can sometimes cause indeterminate results.
See the full story on my blog: https://chenhirsh.com/sql-windows-functions-might-be-non-deterministic/
Thank you for putting together such an easy-to-read and truly informative article. It’s really appreciated. If this matched what you were looking for, suhanz.com has lots more to discover.
Slope Rider One of the scariest things that can happen when you develop SQL code is getting indeterminate results.
Thank you for sharing this information. This blog post is very helpful and will be useful for future posts as well. selectyourgirl