Re: [sqlite] How to get row numbers in a query?

[Jay Sprenkle]

> INSERT INTO tableB ( value, ordering ) SELECT value, count(*) FROM tableA 
> WHERE tableA.value > 4 GROUP BY value ;
> 
> notes the "group by" clauses ...

I don't think that will work:

sqlite> select * from t1;
1|one
2|two
3|three
4|four
sqlite>
sqlite> .schema t1
CREATE TABLE t1(
    Id                INTEGER PRIMARY KEY,
 value text );
sqlite> SELECT value, count(*)
   ...> FROM t1 WHERE value > 2
   ...> GROUP BY value ;
four|1
one|1
three|1
two|1
sqlite>