How to write sql query to generate a group no for each grouped record
<p>following is scenario:</p>

<p>I have data in following format:</p>

<pre><code>    entryid ,          ac_no,   db/cr,     amt
    -----------------------------------------------
    1                   10      D      5   
    1                   11      C      5         
    2                   01      D      8                            
    2                   11      C      8         
    3                   12      D      10         
    3                   13      C      10         
    4                   14      D      5         
    4                   16      C      5         
    5                   14      D      2           
    5                   17      C      2           
    6                   14      D      3           
    6                   18      C      3         
</code></pre>

<p>I want data in following format:</p>

<p>So far i have acheived the first 3 columns by query </p>

<pre><code>select wm_concat(entryid),ac_no,db_cr,Sum(amt) from t1 group by ac_no,db_cr

    wm_Concat(entryid),ac_no, db/cr, Sum(amt),  set_id
    ------------------------------------------------
    1                   10    D      5           S1 
    2                   01    D      8           S1
    1,2                 11    C      13          S1
    3                   12    D      10          S2
    3                   13    C      10          S2
    4,5,6               14    D      10          S3 
    4                   16    C      5           S3
    5                   17    C      2           S3
    6                   18    C      3           S3


I want an additional column `set_id` that either shows this S1, S2.. or any number 1,2.. so that the debit &amp; credit entries sets can be identified.
</code></pre>

<p>I am making sets of debit and credit entries based on their Ac_no values.
Any little help will be highly appreciated. Thanks</p>