MySQL sum elements of a column

by 
 select sum(A),sum(B),sum(C) from mytable where id in (1,2,3);

More Related Contents:

  1. MYSQL sum() for distinct rows
  2. How do I get SUM function in MySQL to return ‘0’ if no values are found?
  3. Surpassing MySQL’s TIME value limit of 838:59:59
  4. How do I add two count(*) results together on two different tables?
  5. Sum until certain point – MySql
  6. get first occurrence of last changed value of a column [closed]
  7. ROW_NUMBER() in MySQL
  8. MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
  9. How can I temporarily disable a foreign key constraint in MySQL?
  10. Creating a “Numbers Table” in MySQL
  11. MYSQL Select MAX Date inside a join statement
  12. Choosing a stand-alone full-text search server: Sphinx or SOLR? [closed]
  13. Determine which MySQL configuration file is being used
  14. Rails, MySQL and Snow Leopard
  15. In SQL, how to select the top 2 rows for each group
  16. MySQL CONVERT_TZ()
  17. TRIGGERs that cause INSERTs to fail? Possible?
  18. Mysql query to dynamically convert rows to columns on the basis of two columns
  19. MySQL: #126 – Incorrect key file for table
  20. MYSQL Left Join COUNTS from multiple tables
  21. Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
  22. Case Sensitive collation in MySQL
  23. MySQL: ALTER IGNORE TABLE ADD UNIQUE, what will be truncated?
  24. Getting first day of the week in MySql using Week No
  25. error code 1292 incorrect date value mysql
  26. How to search for rows containing a substring?
  27. Import CSV to Update only one column in table
  28. MySQL : how to remove double or more spaces from a string?
  29. Error in MySQL library for Node.js
  30. Count duplicates records in Mysql table?

Leave a Comment