MySQL Group by SUM

by 
SELECT cat_name, SUM(amount) AS total_amount
FROM table
GROUP BY cat_name

More Related Contents:

  1. get first occurrence of last changed value of a column [closed]
  2. MySQL – Rows to Columns
  3. ROW_NUMBER() in MySQL
  4. multiple query same table but in different columns mysql
  5. How can I make SQL case sensitive string comparison on MySQL?
  6. 1052: Column ‘id’ in field list is ambiguous
  7. How can I temporarily disable a foreign key constraint in MySQL?
  8. How to do a batch insert in MySQL
  9. Count the occurrences of DISTINCT values
  10. Ordering by the order of values in a SQL IN() clause
  11. Creating a “Numbers Table” in MySQL
  12. SQL Selecting from two Tables with inner join and limit [duplicate]
  13. SQL: selecting rows where column value changed from previous row
  14. Why do results from a SQL query not come back in the order I expect?
  15. How to generate data in MySQL?
  16. MySQL combine two columns and add into a new column
  17. SQL query of multiple values in one cell
  18. How to skip certain database tables with mysqldump?
  19. MySQL error 1241: Operand should contain 1 column(s)
  20. How to set a MySQL row to READ-ONLY?
  21. How to transpose rows to columns with large amount of the data in BigQuery/SQL?
  22. Mysql: Order by like?
  23. Getting first day of the week in MySql using Week No
  24. Is there a way to get the row number in Mysql like the rownum in oracle [duplicate]
  25. How to format number with “.” as thousands separator and “,” as decimal separator?
  26. Using DISTINCT and COUNT together in a MySQL Query
  27. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  28. INSERT INTO Table from multiple tables
  29. Execute INSERT if table is empty?
  30. Mysql How do you create a clustered index?

Leave a Comment