Pregunta de entrevista de The Johns Hopkins University

How would you use the PARTITION functions in SQL Server?