SQL Windows Functions might be non-deterministic
top of page
Search

SQL Windows Functions might be non-deterministic

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.

STAY IN TOUCH

Get New posts delivered straight to your inbox

Thank you for subscribing!

bottom of page