SQLite - SELECT TOP syntax error

Question

I am trying to use the SELECT TOP 1 * FROM tasks WHERE dueDate < ?1 ORDER BY dueDate DESC , but SQLite says near "1": syntax error . What's wrong?

Answer 1

Use LIMIT 1 at the end of the query instead of TOP 1 (which sqlite syntax is not valid).

You may also need to remove ? in dueDate < ?1 , but I don’t know sqlite well enough to be sure.