SQL Divide by Two Count()

Question

I have the following query, which is trying to figure out the percentage of a certain product compared to the total number of products. IE: [Product Count] / [Total Products] = Percent ``` ;WITH totalCount AS( SELECT CAST(COUNT(id) as Integer)as totalCount FROM TABLE_NAME ) SELECT ((CAST(COUNT(DISTINCT id) as Integer)/(SELECT * FROM totalCount))*100) as 'Percent' FROM TABLE_NAME ``` However, the percent column always returns "0" unless there is only one record. In addition, is there a way to add the totalCount and Select query into one? Basically, how do you divide two Count() fields?

Accepted Answer

Cast your total count as a number besides integer (DECIMAL?) - the math rounds off.

SQL Divide by Two Count()

Solution

Problem