SQLite Select an id which is smaller than a number
- by user345039
Hi,
I am trying to only select the objects where the id is smaller than an int value.
e.g.: i have 3 objects - id = 1, id = 2, id = 3
Now I want to only get the objects with the id smaller than the variable i = 2;
How can I manage this?
sql = "SELECT id FROM table_name WHERE id <= i";
Thanks ;-)
