<div>
Looks pretty straight forward to me :-)
</div>


<div>
looks quite simple, <br />
<br />
select sum(b), a from table_name group by a
</div>


looks quite simple,

select sum(b), a from table_name group by a

<div>
fniazi4u,<br />
<br />
Please read previous posts before posting. &nbsp;I don't see anything in your post that I didn't already post 3 hours before yours.
</div>


fniazi4u,

Please read previous posts before posting.  I don't see anything in your post that I didn't already post 3 hours before yours.

<div>
<div class="content wysiwyg-content">
a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b &nbsp; &nbsp;<br />
608679 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;750<br />
608679 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1825<br />
616953 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;750<br />
616953 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1825<br />
620101 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0<br />
620101 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;250<br />
<br />
so the sum should be <br />
<br />
sum(b) &nbsp; &nbsp; &nbsp; &nbsp;a<br />
2575 &nbsp; &nbsp; &nbsp; &nbsp; 608679<br />
2575 &nbsp; &nbsp; &nbsp; &nbsp; 616953 &nbsp; <br />
250 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 620101
</div>
</div>


a           b    
608679	750
608679	1825
616953	750
616953	1825
620101	0
620101	250

so the sum should be 

sum(b)        a
2575         608679
2575         616953   
250           620101

sum by grouping Oracle

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

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.