sqlite 常用的一些语句

转载：https://blog.****.net/qq_25221835/article/details/82768375

转载：https://blog.****.net/qq_35449730/article/details/82955979(最近10条记录)

1.字段是varchar2类型即string，而其实存的是数字，这时候用order by排序

表数据与结构： salary 为 varchar 类型

create table TEST_ROW_NUMBER_OVER(

       id varchar() not null,

       name varchar() null,

       age varchar() null,

       salary varchar() null

);

insert into TEST_ROW_NUMBER_OVER(id,name,age,salary) values(,'a',,'');

insert into TEST_ROW_NUMBER_OVER(id,name,age,salary) values(,'a2',,'');

insert into TEST_ROW_NUMBER_OVER(id,name,age,salary) values(,'b',,'');

insert into TEST_ROW_NUMBER_OVER(id,name,age,salary) values(,'b2',,'');

insert into TEST_ROW_NUMBER_OVER(id,name,age,salary) values(,'c',,'');

insert into TEST_ROW_NUMBER_OVER(id,name,age,salary) values(,'c2',,'');

insert into TEST_ROW_NUMBER_OVER(id,name,age,salary) values(,'d',,'');

insert into TEST_ROW_NUMBER_OVER(id,name,age,salary) values(,'d2',,'');

以 salary 降序

select id,name,age,salary from TEST_ROW_NUMBER_OVER order by cast(salary as integer) desc

2.查询数据库中最近的十条数据，并按时间升序进行排列

select *from ( select * from table1 order by datetime desc limit , ) order by datetime

秒客网

sqlite 常用的一些语句

相关文章