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