Select a Random Row
by xinu on Jan 12, 2005 10:22 AM
Select a random row from a table with the following query:
SELECT * FROM table ORDER BY random() LIMIT 1;
obscurepostgresqlrandomsql
Select a random row from a table with the following query:
SELECT * FROM table ORDER BY random() LIMIT 1;
obscurepostgresqlrandomsql