sql server 2008 - SQL - Percentage count

Question

I have a table called URP_PROJECT, a column named ts_title. There are different record data under column ts_title. How to calculate the each record under ts_title as percentage? Percentage column is added according to the SQL query below.

I start with:

SELECT ts_title

COUNT (ts_title) AS Percentage

Help me continue it, Thank you

Answer 1

this may give you what you are looking for

  select ts_title, 
         count(1) * 100.0 / (select count(1) from upr_project)
 from upr_project
group by ts_title

Multiplying times 100.0 converts it to a float for more accurate percentages.