sqlite-select

参考网页。
https://www.guru99.com/sqlite-query.html#4

limit,offset

跳过前 4 行，最多返回 3 行

SELECT * FROM Students LIMIT 4,3;

选出最新的一行

SELECT * FROM COMPANY ORDER BY NAME DESC limit 1;

选择非空的行

select f_ui_id,f_param from t_user where f_param is not null and f_param !=''

选择日期

select * from table1 where t1>='2017-06-01' and t1<='2017-06-05'

累加

SELECT sum(Amount) FROM "Model_trade_info" WHERE code=12312