Answers for "mysql percentage of total"

mysql percentage of total

SELECT Rep, Sale, Sale * 100 / t.s AS `percent of total`
FROM sales
CROSS JOIN (SELECT SUM(sale) AS s FROM sales) t;

Posted by: Guest on October-14-2021

Code answers related to "mysql percentage of total"