How to get random row from sql query – PostgreSQL
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.
About Author
Founder of Mkyong.com, love Java and open source stuff. Follow him on Twitter. If you like my tutorials, consider make a donation to these charities.
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