KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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?
Tags (comma-separated)
Save Edits
Cancel