What are the differences between GROUP BY and ORDER BY...the manual is not clear on this

GROUP BY is a way to sub-total your results, or perform some 
other "aggregate" function on them.


SELECT department, sum(salary)
FROM tblEmployee
GROUP BY department;

will give you salary totals by department, whereas the sum statement by
itself would just give you the grand total of all salaries in

ORDER BY is simply a way to sort your results - it does not affect what
shows up in your resultset, only what order it is displayed.


FROM tblEmployee
ORDER BY lastname;

will give you all tblEmployee data, in order of last name. If you want
the results in descending (reversed) order, simply add DESC to the end
of the clause:
ORDER BY lastname DESC;

Was this answer helpful?

 Print this Article

Also Read

How do I delete a table from a database?

Use this sql command "DROP TABLE yourtablename"

What does this error message means - Warning: Supplied argument is not a valid MySQL result resource and how do you solve it?

I think you got this message from PHP.You get this message when you're trying to access $result...

I'm new to MySQL, where should I start?

Useful Tutorials:Examples on using MySQL commands:...

How can i select random rows from a table?

SELECT * FROM table_name ORDER BY RAND();Found at...

Does mysql support foreign keys ?

The answer to this is two-fold.Yes. MySQL _DOES_ allow the creation of foreign key constraints...