On Tue, 16 Sep 2014 16:38:09 +0200
RSmith <rsm...@rsweb.co.za> wrote:
> On 2014/09/16 15:32, Paul Sanderson wrote:
> > select _rowid_, * from tab3 does the trick - thanks all
>
> Indeed, and if you are pedantic or do not work in a table with
> rowids, the solution is to explicitly give the table definition
Or not use a temporary table.
http://www.schemamania.org/sql/#rank.rows
Now easier with CTE. In theory it could be *faster* than a temporary
table, because the insertion I/O is avoided. But only testing will
tell.
--jkl
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
