mercredi 5 août 2015

Assign random number in postgresql

I have table in postgresql with statename, districtname and DistID . Now I want to assign random number(starting from 1 to count of district in a particular state) to the column 'DistID' for each district based on their states. Kindly help.




Aucun commentaire:

Enregistrer un commentaire