c# - Generating Sequence number based on the column value -

i want generate sequence number based on column value. want have kind of output. gonna use in c# .net winform gridview output

table1  id        name      nostub  1        arte        3  2       gonzake      2   table2  id      name        stubnumberstart          stubnumberend  1      arte           0001                      0003  2      gonzake        0004                      0005    

try query.. give result table 2 table 1

declare @t1 table (id int, name varchar(50), stubnumber varchar(10)) insert @t1 values ( 1, 'arte', '001') insert @t1 values ( 1, 'arte', '002') insert @t1 values ( 1, 'arte', '003')  insert @t1 values ( 1, 'gonzake', '004') insert @t1 values ( 1, 'gonzake', '005')    select * @t1  select distinct id ,name, count(*) nostub @t1 group id, name 

if request different table 1 table 2 please let me know .. new query...