sql - query - select data by first inserted -


possible duplicate:
select bottom rows in natural order

people imagine have table :

persons

columns of table name , id

and insert

insert persons values ('name','id');  insert persons values ('john','1');  insert persons values ('jack','3');  insert persons values ('alice','2'); 

how can select information order insertion? query :

name id

name id

john 1

jack 3

alice 2

without indexs (autoincrements), it's possible?

i'm pretty sure not. knowldege sql data order not sequetional respect insertion. idea have along each insertion have timestamp , sort time stamp


Comments