SQLite uses ROWID to represent line numbers for pagination.

In the query results of SQLite display line number, you can use the Select rowID as RowNumber, * from Wsclanguage;

Select rowID as RowNumber, * from Wsclanguage ORDER by Createtime;

SELECT DISTINCT keyword from articlecontent;

/* Select Last_insert_rowid () AAA to return to the last record id*/

SELECT * FROM (SELECT * from Articlecontent) Articletab where aid<=500 and createdate between ' 2011-3-13 ' and ' 2011-3 -15 ' ORDER by createdate ASC limit 50;

SELECT * from articlecontent where keyword like ' form% ';

SELECT * from Articlecontent tab1,articlecategories tab2 where tab1.categoryid=tab2.cid;

/*insert articlecontent values (' AAA ', ' ABCDEFG ', ' 2010-01-01 ', ' abc ', 4);

Select Current_timestamp, DateTime (Current_timestamp, ' localtime ');;
Select DateTime ();
Select Date ();
Select time ();
Select DateTime (' 2006-10-17 ');
Select DateTime (' 2006-10-17 00:20:00 ', ' +5 hour ', ' -12 minute ');
Select DateTime (' Now ', ' start of Year ');
Select Strftime ('%y-%m-%d%h:%m:%s ', ' now ');

Select rowID as rownumber,* from articlecontent;/* line number */

SQLite uses ROWID to represent line numbers for pagination.