sql select data in row number

[Larz60+]

DSo here's an example of why you cannot rely on it

Output:
sqlite> Create table TEMP1 ('First' text, 'Last' text);
sqlite> .schema TEMP1
CREATE TABLE TEMP1 ('First' text, 'Last' text);
sqlite> insert into temp1 values('John', 'Smith');
sqlite> insert into temp1 values('Fred', 'Fuller');
sqlite> insert into temp1 values('Jack', 'Rabbit');
sqlite> select rowid from TEMP1;
1
2
3
sqlite> DELETE from TEMP1 where rowid == 2;
sqlite> select rowid from TEMP1;
1
3
sqlite> select rowid, * from TEMP1;
1|John|Smith
3|Jack|Rabbit
sqlite> VACUUM;
sqlite> select rowid, * from TEMP1;
1|John|Smith
2|Jack|Rabbit
sqlite>