Sqlite中使用rowid来表示行号，用于分页。

最新推荐文章于 2022-05-17 22:40:48 发布

a616735104

最新推荐文章于 2022-05-17 22:40:48 发布

阅读量601

点赞数 1

文章标签：数据库

原文链接：http://www.cnblogs.com/songxingzhu/p/3991404.html

版权

在SQLite的查询结果中显示行号，可以使用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 返回最后一条记录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;/*行号*/

转载于:https://www.cnblogs.com/songxingzhu/p/3991404.html