Manipulate duplicate rows

I have two of the exact same rows, but I want to change one field of one of
the rows. How do I do this?

i.e.
table_a
group name revenue
A jim 20
A jim 20

I want to change one jim to ken.

I tried
update table_a
set name = 'ken'
from (select top 1 * from table_a) as t1
where table_a.group = t1.group

but this updates both records
.

Relevant Pages

  • Re: "Antique" cue case
    ... be aware that it is NOT an antique. ... Jim. ... He said he bought the exact same - not different - case. ...
    (rec.sport.billiard)
  • Re: event errors in W2K3
    ... I am getting the exact same errors. ... Jim ... > Event source for all = SideBySide. ... > Description varies: ...
    (microsoft.public.windows.server.general)
  • Re: MacExpo; the Ethiopian connection
    ... Maybe I've not use the exact right term there then JJ .. ... the term 'sock puppet' tends to be used to indicate someone who posts under ... saying 'yes Jim, I agree completely!' ... The droplet of saliva which hangs from them. ...
    (uk.comp.sys.mac)
  • Re: Manipulate duplicate rows
    ... > I have two of the exact same rows, but I want to change one field of one of ... >A jim 20 ... always have a primary key. ... for SQL Server to distinguish one row from the other, ...
    (microsoft.public.sqlserver.mseq)
  • Re: My final System 1 problems (for now)
    ... Thanks a bunch, Jim!! ... Sounds like I might have the exact same problem. ... Prev by Date: ...
    (rec.games.pinball)