I use the query below to display the total number of different topics from my table on a pie chart .
Select COUNT(*) as [Count], Topic FROM [myDatabase].[dbo].[myTable] group by Topic
I would like to display the percentage instead of the count. How could I achieve that?
Thanks for your help.