Home » RDBMS Server » Server Administration » How to shuffle/scramble records with SQL
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.
Previous Topic: Efficiency Problem
Next Topic: Re: dispaly the COLUMNS and data on Tablar style - URL
Goto Forum:
  


Current Time: Mon Dec 23 01:56:49 CST 2024