(un)grouping question

["Rhys Stewart" <rhys.stewart@xxxxxxxxx>]

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