I have a table like below. I need to calculate percentage value for each row based on total column value. How to achieve this with a SQL query?
I am expecting results like this:
Please find the below simple calculation to get result.
(100 / 1000) * 100 = 10
for the first value.
(row value / grand total) * 100
Can you please help me to get 10 as result for the first row value with a SQL query? Thanks in advance.

