Pregunta de entrevista de Ally Financial

1. How to find and delete duplicates in SQL 2. Difference between RANK and DENSE RANK - window functions