Date: Mon, 10 Sep 2007 06:21:54 GMT
As a part of some experimental work I've been doing, I need to write what I think is best described as a stochastic quota query.
I would like to write a query like
SELECT RANDOM 5 COLUMN_FOO FROM TABLE_BAR where RANDOM is like TOP, except that for successive queries, I get a (possibly) different set of 5 COLUMN_FOO values from table TABLE_BAR.
Has anyone seen such a beast?
Thanks in advance,
Joe Received on Mon Sep 10 2007 - 08:21:54 CEST