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.
This article was posted in PostgreSQL category.
Oracle Magazine - Free Magazine
Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for Java's developers and DBAs, and more.
Securing & Optimizing Linux: The Hacking Solution - Free Guide
A comprehensive collection of Linux security products and explanations in the most simple and structured manner on how to safely and easily configure and run many popular Linux-based applications and services.
The Windows 7 Guide: From Newbies to Pros - Free Guide
In this 46 page guide you will be introduced to Windows 7 and what it has to offer. This guide will go over the software compatible issues, you will learn about the new taskbar, how to use and customize Windows Aero, what Windows 7 Libraries are all about, what software is included in Windows 7, and how easy networking is with Windows 7 along with other topics.
All Java Tutorials
- Java Core Technology - Java RegEx, Java XML, Java I/O, Java Misc
- J2EE Frameworks - Hibernate, Spring 2.5, Spring MVC, Struts 1.x, Struts 2.x
- Build Tools - Maven, Archiva
- Unit Test - jUnit, TestNG
- Client Scripts - jQuery
3 Comments
Leave a Reply
Loading ... Loading ... Loading ... Loading ... Loading ...
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