[RBG7-L] - RE: Duplicate row identification

[Walker, Buddy]

Robert
  You can try..
 
   update thisTable set somecolumn = 'X' where itemno in +
  (select itemno from thatTable group by itemno having count(*) > 1)
 
Buddy
 
 
-----Original Message----- 
From: [EMAIL PROTECTED] on behalf of Robert Vincent 
Sent: Sat 12/18/2004 9:18 AM 
To: RBG7-L Mailing List 
Cc: 
Subject: [RBG7-L] - Duplicate row identification




        R:Greetings, 

        I seem to recall an SQL syntax that would allow me to 
        identify duplicate rows within a column of a single 
        table. 

        I need to flag rows in a table where an item number 
        already exists within that table. 

        Something like: 
        UPDATE {table} SET {column}='X' where itemno in + 
          (select itemno from {table}) 

        Of course the statement above flags ALL rows, but I 
        thought there was a way to indicate rows that 
        existed more than once. 

        TIA - Rob Vincent 

<<winmail.dat>>