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
- [sqlite] Retrieve Rownumber in sqlite Kalyani Phadke
- Re: [sqlite] Retrieve Rownumber in sqlite Neville Franks
- Re: [sqlite] Retrieve Rownumber in sqlite Dennis Cote