This is a problem I faced As I have a large database of meteorological data, I want to get random rows to manipulate through a model. I used a column with a random number in the ORDER BY statement. Here are my trials and their drawbacks:
1- I tried to use a column with rnd() function. It returns the same number for all records!
2- I combined the row number with the random function as: rnd([ID]). It returns a new number for each record, but the whole set of numbers is repeated every time!
3- Finally, I found the answer that I want to share with you.
Best regards for all.
Aucun commentaire:
Enregistrer un commentaire