SQL Window Functions

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.