How I can make a SQL syntax to generate "RANDOM SELECTION" in Select by attributes tool in ArcMap?.

E.g. We have two kind of sample: Quantitative an Qualitative data.

  • Quantitative (seven cases): 1,2,5,8,23,76,99,567,34,596,36,28,11

  • Qualitative (four cases): "dogs","parrots","lions","cats","turtles","tigers","pigs" and "ducks".

My aim is generate a random selection in quantitative cases, just seven cases of the whole sample (e.g. 34,5, 28, 596 and 2). And qualitative cases, just four cases of the whole sample (e.g. "pigs", "cats","tigers" and "dogs").

How I can make it?

Is it the same to mix quantitative(Double Type) and qualitative (String Type) cases?

I don't know how to use arcgis.rand() and pythons random.

Can you teach me step by step thoguh Field Calculator or Select by attributes?

Like this picture...

I think this in vbscriptenter image description here

The idea is to do random selections in COD_MOD variable (0515012, 4789512, 4563728, etc). In addition, I want to have a random selection with 1000 features as maximum.