Sqlite3 top query and limit syntax Introduction

In fact, there is no top syntax structure in sqlite3, but there are related syntaxes in sqlite3 to implement the same functions as top syntax. sqlite3 SQL is implemented using limit syntax;

For example:CopyCodeThe Code is as follows: Select * from table where name = '_ quiet comment 'order by ID limit;

This effect is equivalent to select top 10 * from table where name = '_ quiet comment ';

If there is more accurate:Copy codeThe Code is as follows: Select * from table where name = '_ quiet comment 'order by date DESC, Id limit;