If you get no rows returned, you could query SELECT COUNT(*) FROM table1; (If you get rows returned, you know that the number skipped is the size of your offset.)
On Thu, Dec 6, 2012 at 11:44 AM, Steffen Mangold < steffen.mang...@balticsd.de> wrote: > Hi, > > I want to know if there is a possibility to count the infact passed row if > I make an OFFSET SELECT. > For example: > > table1 > ----------- > Row1 > Row2 > Row3 > Row4 > Row5 > > > Select * from table1 Order by rowID DESC Lilit 2 Offset 10; > > Here the Result is null, but I want to detect that I passed 5 existing > rows. > > regards > > Steffen Mangold > > _______________________________________________ > 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