>>>>> Tarun writes:
[…]
> I planned to execute query that works on SQL ROWNUM option
> "select * from employee2 where rownum > 10000 and rownum < 20000"
Perhaps:
SELECT * FROM employee2 ORDER BY oid LIMIT 10000 OFFSET 10000
> but i m getting error from sqlite3 that "no such column: rownum"
> Please help me to achieve "read records in chunks". I am stuck.
> Thanks in advance.
--
FSF associate member #7257 Coming soon: Software Freedom Day
http://mail.sf-day.org/lists/listinfo/ planning-ru (ru), sfd-discuss (en)
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
