SQL window functions interactive demo showing how RANK() and DENSE_RANK() handle tied rows

SQL Window Functions Explained: 7 Powerful Techniques (With a Live Demo)

RANK() and DENSE_RANK() appear practically identical until you reach a tie, and that single difference causes more SQL interviews than anything else. Here’s an interactive description of each of the 7 window function strategies, along with a live demo you can try yourself.

SQL Window Functions Explained: 7 Powerful Techniques (With a Live Demo) Read Post »