Sum Amount, display full resultset where Groups of Column Values Match in Same Table Oracle SQL
<p>I need to get the sum of all TOTAL fields where the ID, RECNO and DRCR fields have the same value, while also displaying these fields in the result set. 
eg</p>

<pre><code>ID     RECNO      SECRECNO    DRCR    TOTAL
 1        9         5           D       25
 1        9         12          D       22
 1        9         6           C       33
 1        9         5           D       50
 1        8         2           D       12
 1        8         2           C       23
 2        9         5           D       100
</code></pre>

<p>So the results of the query should be </p>

<pre><code>ID     RECNO      SECRECNO    DRCR    SUM(TOTAL)
 1       9           5         D        75
 1       9           12        D        22
 1       9           6         C        33
 1       8           2         D        12
 1       8           2         C        23
 2       9           5         D        100
</code></pre>

<p>This query will give the results set, without the TOTAL:</p>

<pre><code>select distinct t1.recno, t1.secrecno
from table t1, table t2
where t1.recno = t2.recno and t.id = '1' and t1.drcr = 'D'
</code></pre>

<p>But I can't see how to SUM the TOTAL of these results. 
How to do this?</p>