[Solved] SQL for calculating percentage of values for same column [closed]

Question

select sum(case when Column2 = 'somevalue' then Column1 else 0 end) * 100 / sum(Column1) from NAMES;

See this:-

Select percentage of rows that have a certain value – SQL

Accepted Answer

select sum(case when Column2 = 'somevalue' then Column1 else 0 end) * 100 / sum(Column1) from NAMES;

See this:-

Select percentage of rows that have a certain value – SQL