Stochastic Queries

From: Joe Thurbon <usenet_at_thurbon.com>
Date: Mon, 10 Sep 2007 06:21:54 GMT
Message-ID: <6o5Fi.33482$4A1.28838_at_news-server.bigpond.net.au>

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