what is the difference between GROUP BY and ORDER BY in sql

by

ORDER BY alters the order in which items are returned.

GROUP BY will aggregate records by the specified columns which allows you to perform aggregation functions on non-grouped columns (such as SUM, COUNT, AVG, etc).

TABLE:
ID NAME
1  Peter
2  John
3  Greg
4  Peter

SELECT *
FROM TABLE
ORDER BY NAME

= 
3 Greg
2 John
1 Peter
4 Peter

SELECT Count(ID), NAME
FROM TABLE
GROUP BY NAME

= 
1 Greg
1 John 
2 Peter

SELECT NAME
FROM TABLE
GROUP BY NAME
HAVING Count(ID) > 1

=
Peter

More Related Contents:

  1. MySQL query finding values in a comma separated string
  2. In MySQL queries, why use join instead of where?
  3. SQLite INSERT – ON DUPLICATE KEY UPDATE (UPSERT)
  4. Can table columns with a Foreign Key be NULL?
  5. MySQL not using indexes with WHERE IN clause?
  6. MySQL dump by query
  7. single fixed table with multiple columns vs flexible abstract tables
  8. How many rows in a database are TOO MANY?
  9. SQLite – ORDER BY RAND()
  10. SQL – How to transpose?
  11. Which SQL query is better, MATCH AGAINST or LIKE?
  12. MySQL equivalent of DECODE function in Oracle
  13. How to delete Duplicates in MySQL table
  14. Best database field type for a URL
  15. Query that ignore the spaces
  16. How to Optimize Queries in a Database – The Basics
  17. MySQL – how to front pad zip code with “0”?
  18. Create date from day, month, year fields in MySQL
  19. Find rows that have the same value on a column in MySQL
  20. How do I list all the columns in a table?
  21. Two single-column indexes vs one two-column index in MySQL?
  22. VARCHAR as foreign key/primary key in database good or bad?
  23. How to find all IDs of children recursively?
  24. How can I do a FULL OUTER JOIN in MySQL?
  25. How do I see what character set a MySQL database / table / column is?
  26. Decision between storing lookup table id’s or pure data
  27. How Can I use “Date” Datatype in sql server?
  28. Adding a leading zero to some values in column in MySQL
  29. Primary key or Unique index?
  30. Is it possible to have an indexed view in MySQL?

Leave a Comment