> R Smith: > > Simply add a column to any select like this: et voila...
I tried without "partition by 1" and that works as well: "row_number() OVER ()" _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users