Have a look at this thread in the archive: find sequential groups It can be done with SQL, but it is slow and it can be done enormously faster in code. I did this in VB6 and let me know if you are interested and I mail you the code off-list.
RBS On Sat, Apr 27, 2013 at 8:10 AM, hiteshambaliya <hitesh.ambal...@gmail.com>wrote: > You are absolutely right but, > I am using VB 6.0 and i have global general function which fill the data in > grid so there is if serial number column in query is easy way so.. > > Any way to do in query??? > > > > -- > View this message in context: > http://sqlite.1065341.n5.nabble.com/sequential-row-numbers-from-query-tp47370p68506.html > Sent from the SQLite mailing list archive at Nabble.com. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users