Hi
What would be the best way to select a random row from a result set?
Possibilities:
1) o get the total number of rows using count() o generate a random number between 1 and the total o select the n'th
rowusing OFFSET
2) o get the total number of rows using count() o generate a random number between 1 and the total o fetch n times
Option 1 uses 'OFFSET' which is a database-specific keyword, which is
probably bad.
Also, is there a way to randomize the order of a result set?
Thanks in advance
Jelle Ouwerkerk
Software Developer
Openface Internet Inc.
Montreal, Quebec, Canada
http://www.openface.ca