Mysql GROUP BY, ORDER BY

[Anon]

Hi,

Could someone tell me what's the difference between GROUP BY and ORDER BY?
I always use GROUP BY but I'd like to know wether it'd be faster with ORDER BY or not...

Sorry for this silly question,

David

[Anon]

GROUP BY should be used when you want (for example) some statistics.
ORDER BY should be used when you want to sort a query according to an column:

example : TABLE people

name age

---

durand 25
francois 30
francois 32
georger 22
zeen 17

some queries

SELECT name FROM people ORDER BY age

name

zeen
georger
durand
francois
francois

SELECT name, count(*) as nb FROM people GROUP BY name ORDER BY nb, name

name nb

francois 2
durand 1
georger 1
zeen 1

I hope that is simple enough 🙂)

Jean-Michel