· 7 years ago · Nov 07, 2018, 10:56 AM
1SELECT * FROM MyTable WHERE ID >= 5 && ID <= 15;
2
3CREATE TEMPORARY TABLE IF NOT EXISTS TmpMyTable (ID INTEGER, MyValue TEXT);
4INSERT INTO TmpMyTable SELECT * FROM MyTable WHERE ID >= 5 && ID <= 15;
5SELECT * FROM TMP_Smile_Data_3 WHERE rowid >= 100 AND rowid <= 300;