rownumber = 0 do while ThereAreRows: sqlite3_step ... rownumber += 1 ...
pretty simple eh? > -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Tony Papadimitriou > Sent: Monday, 1 July, 2013 03:33 > To: General Discussion of SQLite Database > Subject: [sqlite] Is there a way to return the row number? (NOT the > rowid) > > Is there a function (or method), e.g., row(), to return the sequence > number > of the selected row? This is not the same as ROWID. row() should > give a > sequence number always starting from 1 up the to the number of rows > returned > by the view/select etc. > > If not, then please add to the wish list. > > TIA > > _______________________________________________ > 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