vendredi 29 septembre 2017

Random selection in Netezza

I need help with a random selection in Netezza.

I have for example 4 customers and each one has some options for a variable.

Customer 1: 4,5,6

Customer 2: 10,12,16

Customer 3: 1,2,3,4,5,6

Customer 4: 5,8

And I need to select only one option for each Customer using a random selection.

Thanks!




Aucun commentaire:

Enregistrer un commentaire