jeudi 8 août 2019

removing duplication on random when doing an insert

Good DAy you guys, I am new to sql, netezza, etc...I have been tasked with manipulating actual account numbers for outside company upload of file, I am currently using Netezza, when I create a table and randomize an account number, there are no duplication but when I insert into table after, the random number duplicates(not a lot, but it does) and each random number has to be unique to each distinct account number.

Thank you guys

I am currently trying to use a loop statement but dont know how to build it in




Aucun commentaire:

Enregistrer un commentaire