jeudi 1 août 2019

Random record from the table

I have customer table with 10 columns. In the table customer id is repeated. I need to take only one record every customer but randomly.

Let suppose customer table contain total 10000 records. But distinct customers is only 500.

So i need only 500 distinct customer data randomly.

I am using mysql 5.7.




Aucun commentaire:

Enregistrer un commentaire