[MLUG - DISCUSSION] semi-random results from sql

[Michael <EMAIL:PROTECTED>]

If you recall I was looking for a way to get random listing from SQL db's.
This is what I came up with that seems to work best.. in case anyone else
is interested. Where the x and the y can be taken from randomly generated
numbers. I found 1 < x > 100 and -1 < y > 3 worked pretty well.

`select id from mytable where (id % x = y) limit l`

--
To unsubscribe, go to http://mlug.missouri.edu/members/edit.php

Archives are available at http://mlug.missouri.edu/list-archives/