Re: [sqlite] Retrieve Rownumber in sqlite
Kalyani Phadke wrote: > In SQL Server2005, Row_number() function is used to retrieve the > sequential number of a row within a partition of a result set, starting > at 1 for the first row in each partition. Which is very useful when > implementing paging through a large number records in Table. Is there > any function available in SQLite similar to this. > See http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor for a discussion of paging results that is fast and does not require a row_number for the entries. HTH Dennis Cote ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Retrieve Rownumber in sqlite
Hi Kalyani, There is a column named ROWID which gives you the internal row number. Saturday, March 1, 2008, 9:32:44 AM, you wrote: KP> In SQL Server2005, Row_number() function is used to retrieve the KP> sequential number of a row within a partition of a result set, starting KP> at 1 for the first row in each partition. Which is very useful when KP> implementing paging through a large number records in Table. Is there KP> any function available in SQLite similar to this. KP> Thanks KP> -Kalyani -- Best regards, Neville Franks, http://www.surfulater.com http://blog.surfulater.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Retrieve Rownumber in sqlite
In SQL Server2005, Row_number() function is used to retrieve the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition. Which is very useful when implementing paging through a large number records in Table. Is there any function available in SQLite similar to this. Thanks -Kalyani ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users