Wednesday, May 13, 2009

postgresql select distinct with random

select distinct categoryid FROM search_random where categoryid in(select categoryid from search_random order by random() limit 8) limit 4

No comments:

Post a Comment