We Heart Code

I was doing some work this afternoon, and I needed some sample id's from a database query, however all the data ended up being related to the same person because of the ordering of the results. There must be a better way, i want random results in my resultset.

Here's how (in oracle), order by a random value using dbms_random.value()

Bookmark to: