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.

Example :

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 tblEmployee.

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.

Example :

SELECT *
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;

  • 18 Usuários acharam útil
Esta resposta lhe foi útil?

Artigos Relacionados

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

The best source of MySQL information is the excellent on-line manual : ...

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 are trying to access...

How do I delete a table from a database?

Use this SQL command : "DROP TABLE yourtablename"

How can I select random rows from a table?

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

Select statement to join tables?

For a simple join: SELECT a.*, b.*FROM tblAlpha a, tblBeta bWHERE (a.keyfield = b.foreignkey);...