[Resolved] Order By & Group By

[________]

What's the diffrence between Order by and Group by...
I know that order by sorts the data for a-z or 1-9... but what does Group by do?
And when should I use it?

[barand]

use grou when you need to aggregate field values or count records. For example if you have an employee database and, for each department, you want number of employees and average salary and total salary

SELECT AVG(salary) as avsal, count(*) as numemps, SUM(salary) as totsal, dept FROM employee GROUP BY dept.

hth

[________]

Ok, I got it.
Thanks!