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.
Very nice SELECT, I use it to display random pictures from the database on a website.
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)…
True, with huge records it slows down retrieval
ic… thanks for info