Pergunta de entrevista da empresa The Johns Hopkins University

How would you use the PARTITION functions in SQL Server?