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. 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 as below.
Best regards for all.
Aucun commentaire:
Enregistrer un commentaire