Jan 06, 2009 - 12:19 AM
It sounds like you want mix some randomness into the result. Randomness is not usually in the nature of SQL, but I suppose the RAND() function could be helpful here.
Another way to get 50% into the mix is to simply select two result sets (with the same number of rows - and none repeated in the two) and put them together with a UNION. In this case you would select the ones with collection="TEST_1" and then the ones with NOT collection="TEST_1".
If you could clarify what you need and if any of this was in the right direction, it would be helpful.
Oct 06, 2010 - 02:06 AM