How to get random row from sql query – PostgreSQL
Written on
August 11, 2008 at 9:58 am by
mkyong
How can i get a random row from a query result in PostgreSQL?
The answer is easy, just using RANDOM() built-in function in PostgreSQL
SELECT scoreid FROM n_score ORDER BY RANDOM() LIMIT 1;
Above example will get a random score id from table n_score. Everytime execute it will get a random score id. Done.



simple code but essencial for testing your data
Keep up the good work
Just keep in mind that sql own random functions have big speed impact (internally its selecting all rows anyways and picking random one then)…
ic… thanks for info