How to shuffle/scramble records with SQL [message #372495] |
Thu, 15 February 2001 10:02 |
Martin
Messages: 83 Registered: February 2000
|
Member |
|
|
I have a table that I want to read through sequentially. The challenge is, each time the program is run I want to process the records in a different order, kind of like 'shuffling the deck' of a deck of cards. I can't think of a way to do it. There are only about 300 records so I could read them into a table in a program and then scramble them, but how? Please advise.
|
|
|