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
