Hi list, have the following table
uid|somevalue -------------------- 1|11 2|44 3|31 4|44 5|71 6|33 7|33 8|44 9|14 would like to remove the duplicate values in the column somevalue. doing this by just adding a random number is perfectly fine, however i want to retain at least one of the original values of somevalue. Any ideas how to do this in in a query? Rhys, Peace & Love|Live Long & Prosper
