SQLite paging is the simplest in the world

At the beginning, I didn't pay attention to the syntax.
Later, we found that using SQLite paging is the simplest in the world.
If I want to go to the account table data from 11 to 20
Select * from account limit 9 offset 10;
The preceding statement retrieves data from the account table, skipping 10 rows and taking 9 rows

Well, I think this feature is enough for many medium-sized websites.

You can also write select * from account limit10, 9 in the same way as above.
This writing method is also supported by MySQL.