Getting percentage of “Count(*)” to the number of all items in “GROUP BY”

by 
SELECT Category, COUNT(*) AS Total , (COUNT(*) / (SELECT COUNT(*) FROM Item WHERE Department="Popular")) * 100 AS 'Percentage to all items', 
FROM Item
WHERE Department="Popular"
GROUP BY Category;

I’m not sure of the MySql syntax, but you can use a sub-query as shown.

More Related Contents:

  1. SELECTING with multiple WHERE conditions on same column
  2. grant remote access of MySQL database from any IP address
  3. Should MySQL have its timezone set to UTC?
  4. JDBC batch insert performance
  5. SQL – Update multiple records in one query
  6. How to find gaps in sequential numbering in mysql?
  7. Can I create view with parameter in MySQL?
  8. MySQL: Invalid use of group function
  9. MySQL show status – active or total connections?
  10. MySQL dynamic pivot table
  11. mySQL DataSource on Visual Studio 2012
  12. MySQL update case help
  13. Dropping Unique constraint from MySQL table
  14. MySql Transpose Row into Column and Column into Row [duplicate]
  15. Dump a mysql database to a plaintext (CSV) backup from the command line
  16. Mysql permission errors with ‘load data’
  17. How to select column names dynamically in mySQL
  18. Using MySQL JSON field to join on a table
  19. How would I use ON DUPLICATE KEY UPDATE in my CodeIgniter model?
  20. MySQL concatenating all columns
  21. MySQL Join Where Not Exists
  22. Correct MySQL configuration for Ruby on Rails Database.yml file
  23. Database corruption with MariaDB : Table doesn’t exist in engine
  24. How to SELECT by MAX(date)?
  25. MYSQL declaring variables
  26. get a recursive parent list
  27. MYSQL – Split Data Into Multiple Rows
  28. List of Constraints from MySQL Database
  29. MySQL Recursive get all child from parent
  30. is it possible to call a sql script from a stored procedure in another sql script?

Leave a Comment