SQL Tip: Window Functions Can Produce Inconsistent Results
SQL window functions can be very useful when it comes to high power manipulation of your datasets. However, it is important to understand the importance of using the correct tie breakers to ensure you have consistent results.