Hello all

I want to get this kind of output from a sql statement,

select start,end from counter

in counter.dbf it had this data

start end
1 5
6 7
8 10

but what i want is to add a column block with continious numbers.

block start end
1 1 5
2 6 7
3 8 10

Thanxs for any input