Re: Select Single Random Record
Oleg Broytman <[email protected]>
| Newsgroups | gmane.comp.python.sqlobject |
|---|---|
| Message-ID | <[email protected]> |
On Wed, Apr 18, 2012 at 12:30:10PM -0400, Adam Berg <[email protected]> wrote: > What is the best way to select a single random record from a table and > falls within the "where" criteria i have defined? I don't want to return a > huge result set each time and then pick a random one Please define "random" in the context of your task. Do you want a different record every time? Or some non-deterministic record that could be the same every time is a possible solution? Oleg. -- Oleg Broytman http://phdru.name/ [email protected] Programmers don't die, they just GOSUB without RETURN. ------------------------------------------------------------------------------ Better than sec? Nothing is better than sec when it comes to monitoring Big Data applications. Try Boundary one-second resolution app monitoring today. Free. http://p.sf.net/sfu/Boundary-dev2dev