Pergunta de entrevista da empresa Yahoo

Describe the difference between GROUP BY and ORDER BY

Resposta da entrevista

Sigiloso

4 de ago. de 2011

ODER BY: sorts the values based on the given criteria in a query GROUP BY: groups the results of a query, put to its best use if used with an aggregate function like COUNT(*), SUM() etc..