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