sqlite3 一些好用的SQL语句

1）升序查询
select *from table_name [where column_name = column_value];
中括号中的内容表示可选；
2）降序查询
select *from table_name [where column_name = column_value] order by column_name2 desc;
中括号中的内容表示可选；
3）只保留最新的n条记录
DELETE FROM table_name WHERE column_name NOT IN (SELECT column_name2 FROM table_name ORDER BY column_name3 DESC LIMIT n_record);