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/
If you want to create your own corner of the Internet, be it a blog, a store or a creative space, Fourthwall opens up countless possibilities. Everything is intuitive, but if something suddenly does not work, the fourthwall customer service is always ready to help. The support team responds quickly, explains everything in simple terms and helps make the project a success.