Sqlite3 Top's query and limit syntax introduction _sqlite

In fact, there is no top grammar structure in the sqlite3, but in the sqlite3 has the relevant syntax to achieve the same function as the top syntax, sqlite3 SQL is limit such syntax to achieve;

Such as:

Copy Code code as follows:

SELECT * FROM table where name= ' _ Quiet ゝ ' ORDER by ID limit 0, 10;

This effect is equivalent to select top * from table where name= ' _ Quiet ゝ ';

If there are more accurate:

Copy Code code as follows:

SELECT * FROM table where name= ' _ Quiet ゝ ' ORDER by date Desc,id limit 0, 10;