Yahoo Interview Question

Describe the difference between GROUP BY and ORDER BY

Interview Answer

Anonymous

Aug 4, 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..