Hi
How to Split every 1000 records from table in SQLite DB?
Extract table with records from SQLite DB and want to split number of records
example below:
from 1 to 999 and
1000 to 1999 and
2000 to 2999 and
3000 to 3999 etc
Hi
How to Split every 1000 records from table in SQLite DB?
Extract table with records from SQLite DB and want to split number of records
example below:
from 1 to 999 and
1000 to 1999 and
2000 to 2999 and
3000 to 3999 etc
Hey,
Do you want to have all these selections in seperate KNIME tables? What are you going to do next with them? This information is crucial for me to suggest an efficient solution.
If the problem is the SQL, give this query a try (https://sqlite.org/lang_select.html):
SELECT * FROM table ORDER BY tablekey LIMIT x OFFSET y
Cheers,
Marten