SQLite Forum

select in order
Login
Yet another simple way:
```sql
sqlite> create table p (id integer primary key autoincrement, other);
sqlite> insert into p values (null,'one'), (null,'two'), (null,'three'), (null,'four');
sqlite> select id,other from p order by id;
id      other
1       one
2       two
3       three
4       four
```
(I'd like to be able to insert into the table without having to put in the placeholder for the id, but I can't figure out how.)