SQLite - SELECT TOP syntax error [duplicate]

Question

I'm trying to use the statement 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 isn't valid sqlite syntax).

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