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
