<div>
select distinct id, sum(units) over(partition by id) / count(*) over() as Unitspercentage<br />
from myTable
</div>


select distinct id, sum(units) over(partition by id) / count(*) over() as Unitspercentage
from myTable

<div>
<div class="content wysiwyg-content">
I have a table with the columns Id(int), Units(int), ItemId(int), MyText(string)<br />
I want to find all &quot;Units&quot; with itemId=2 and add them all together. Then I want to find how many percent the Units in each row is of the total number and return as &quot;UnitsPercentage&quot;. &nbsp;How do I do that?<br />
<br />
Example:<br />
Row1: &nbsp;Id=1, Units=2, ItemId=2, MyText=&quot;Blue&quot;<br />
Row2: &nbsp;Id=2, Units=4, ItemId=2, MyText=&quot;Green&quot;<br />
Row3: &nbsp;Id=3, Units=3, ItemId=2, MyText=&quot;Yellow&quot;<br />
Row4: &nbsp;Id=4, Units=1, ItemId=2, MyText=&quot;Red&quot;<br />
<br />
Return: <br />
Id=1, UnitsPercentage=&quot;20&quot;<br />
Id=2, UnitsPercentage=&quot;40&quot;<br />
Id=3, UnitsPercentage=&quot;30&quot;<br />
Id=4, UnitsPercentage=&quot;10&quot;
</div>
</div>


I have a table with the columns Id(int), Units(int), ItemId(int), MyText(string)
I want to find all "Units" with itemId=2 and add them all together. Then I want to find how many percent the Units in each row is of the total number and return as "UnitsPercentage".  How do I do that?

Example:
Row1:  Id=1, Units=2, ItemId=2, MyText="Blue"
Row2:  Id=2, Units=4, ItemId=2, MyText="Green"
Row3:  Id=3, Units=3, ItemId=2, MyText="Yellow"
Row4:  Id=4, Units=1, ItemId=2, MyText="Red"

Return: 
Id=1, UnitsPercentage="20"
Id=2, UnitsPercentage="40"
Id=3, UnitsPercentage="30"
Id=4, UnitsPercentage="10"

Calculate percentage

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.