sqlite> create table t_user(userid int,username varchar(20));
sqlite> insert into t_user values(1,'u1');
sqlite> insert into t_user values(2,'u2');
sqlite> insert into t_user values(3,'u3');
sqlite> insert into t_user values(4,'u4');
sqlite> insert into t_user values(5,'u5');
问题1 从第二行(含)开始取两条数据
SELECT * FROM T_USER LIMIT 2,2;
注意
1 索引是从0开始的.
转载请注明出处.
写博客的目的:记录,升华,量变到质变