read the whole article: Nondeterministic Row Numbers (SQLMag.com)
The row_number function is an extremely powerful tool that I use to simplify and optimize solutions to many problems. Occasionally I needed to calculate nondeterministic row numbers where order didn’t matter.
No comments:
Post a Comment