Get column sum and use to calculate percent of total (mySQL)

by

You just need to CROSS JOIN the SUM() of Number column:

SELECT Name, Number, Number * 100 / t.s AS `% of total`
FROM mytable
CROSS JOIN (SELECT SUM(Number) AS s FROM mytable) t

Demo Here

More Related Contents:

  1. get first occurrence of last changed value of a column [closed]
  2. MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
  3. multiple query same table but in different columns mysql
  4. How can I make SQL case sensitive string comparison on MySQL?
  5. Import data in MySQL from a CSV file using LOAD DATA INFILE
  6. How to do a batch insert in MySQL
  7. Get current AUTO_INCREMENT value for any table
  8. Creating a “Numbers Table” in MySQL
  9. Choosing a stand-alone full-text search server: Sphinx or SOLR? [closed]
  10. Determine which MySQL configuration file is being used
  11. INSERT INTO … SELECT FROM … ON DUPLICATE KEY UPDATE
  12. Rails, MySQL and Snow Leopard
  13. MySQL CONVERT_TZ()
  14. mysql trigger stored trigger is already used by statement which invoked stored trigger
  15. Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
  16. Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
  17. mysql update query with sub query
  18. What is the difference between the backtick and the square bracket in SQL statements?
  19. Comma separated string of selected values in MySQL
  20. MySQL InnoDB: autoincrement non-primary key
  21. How to insert a file in MySQL database?
  22. What does SQL Select symbol || mean?
  23. Foreign key to one of many tables?
  24. What’s the recommended way to connect to MySQL from Go? [closed]
  25. What is wrong with my SQL here? #1089 – Incorrect prefix key
  26. MySQL. Can’t create table errno 150
  27. How to find all the relations between all mysql tables?
  28. Incorrect integer value: ” for column ‘id’ at row 1
  29. Inventory management with stock options
  30. Working with INTERVAL and CURDATE in MySQL

Leave a Comment