ROW_NUMBER vs RANK vs DENSE_RANK: one of them silently duplicates your Top-N

I was reviewing a "top 3 products per category" report last week and found a bug that had been live...