SQL queries that do not work under SQLite in a C# application

Question

Hello,

I am developing an application in C# with WinForms using SQLite as a database.
The problem, is that I realize that some SQL queries do not work with SQLite.

For example, the SQL commands below do not work with SQLite.

SELECT TOP 50 * FROM Movies ORDER BY MoviesId;

SELECT TOP 100 * FROM Movies WHERE MoviesId NOT IN (SELECT TOP 50 MoviesId FROM Movies ORDER BY MoviesId);

Do you have a variant of these SQL queries that works under SQLite, please?

Thanks.

Answer 1

Try these queries:

SELECT * FROM Movies ORDER BY MoviesId LIMIT 50
SELECT * FROM Movies ORDER BY MoviesId LIMIT 50 OFFSET 50
SELECT * FROM Movies ORDER BY MoviesId LIMIT 50 OFFSET 100