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