mysql percentage of total

httperror451 answered on October 14, 2021 Popularity 1/10 Helpfulness 1/10

answer mysql percentage of total

Comment

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

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: mysql percentage sql

Link to this answer
Share Copy Link

Contributed on Oct 14 2021

httperror451

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.