sqlite限制查询数据数量limit data

sqlite> 
select datetime(CreateTime, 'unixepoch', 'localtime'),Message,Des from Chat_af863d30e1c1e5eba27a0df37a75dba0 where ROWID < 2;

+------------------------------------------------+----------+-----+
| datetime(CreateTime, 'unixepoch', 'localtime') | Message  | Des |
+------------------------------------------------+----------+-----+
| 2013-08-22 18:54:13                            | 网络不好 | 1   |
+------------------------------------------------+----------+-----+
1 row in set

相关推荐