<div>
<div class="content wysiwyg-content">
I like to have a query to add all the type A+B salary together for each yr_mon. &nbsp;Help me on the query please. &nbsp;Thanks.<br />
<br />
Here is the table data.<br />
yr_mon &nbsp; &nbsp; &nbsp;type &nbsp;salary &nbsp; &nbsp; &nbsp;<br />
2008_01 &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100 &nbsp; &nbsp; &nbsp;<br />
2008_01 &nbsp; &nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200 &nbsp; &nbsp; <br />
2008_02 &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;300 &nbsp; &nbsp; &nbsp;<br />
2008_02 &nbsp; &nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;400 &nbsp; &nbsp; &nbsp;<br />
2008_02 &nbsp; &nbsp; &nbsp;C &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;500 &nbsp; &nbsp; &nbsp;<br />
<br />
Here is my result data. &nbsp;<br />
yr_mon &nbsp; &nbsp; &nbsp; &nbsp;salary &nbsp; &nbsp; &nbsp;<br />
2008_01 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300 &nbsp; &nbsp; &nbsp;<br />
2008_02 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 700 &nbsp; &nbsp; &nbsp;
</div>
</div>


I like to have a query to add all the type A+B salary together for each yr_mon.  Help me on the query please.  Thanks.

Here is the table data.
yr_mon      type  salary      
2008_01      A           100      
2008_01      B            200     
2008_02      A            300      
2008_02      B            400      
2008_02      C            500      

Here is my result data.  
yr_mon        salary      
2008_01                 300      
2008_02               700      

query question to add value of two rows together

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.