On Jan 21, 2008 11:36 AM, Rhys Stewart <rhys.stewart@gmail.com> wrote:
> 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?
I can get you halfway there. You want a query something like this to
identify all but one of the values:
select a.uid from sometable a left join sometable b on
(a.somevale=b.somevalue and a.uid > b.uid)
From there, you'll have to figure out the update part of problem. :)