Yes; essentially you base the row to be selected on a "random event" like the "current timestamp".
Originally Posted by jwedeking
There has been a thread on this forum before with exactly this question.
E.g., with PostgreSQL, you can write
but this is clearly SQL "dialect"; there are standard SQL ways to do this (using e.g. the current timestamp).
ORDER BY random()
Last edited by Peter.Vanroose; 08-17-06 at 15:39.
__IBM Certified Database Administrator, DB2 9 for z/OS
__IBM Certified Application Developer
__ABIS Training and Consulting