I need to get some random rows from a large(ish) table. The following seems to be the most straight forward - but not the fastest.
SELECT * FROM table ORDER BY random() limit 200 Is there a faster/better approach? cheers, Torsten _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users