Pergunta de entrevista da empresa Johnson Controls

Difference between partition by and group by SQL