If Id is unique value, like this:
Id | col2 | col3 | col4 | col5 | isUnique | dbUnique
1 | red | 3M | 1995 | UK | 1 | null
2 | red | 3M | 1995 | UK | 0 | null
3 | red | 3M | 1995 | UK | 0 | null
4 | red | 3M | 1995 | UK | 0 | null
5 | pink | A4 | 2002 | USA | 1 | null
6 | pink | A4 | 2002 | USA | 0 | null
(not: 1, 2,
2, 3, 4, 5) the fallowing instruction:
SELECT col2, Count(col2) AS CountOfCol2, Min(ID) AS MinOfID
FROM Table1
GROUP BY col2
HAVING (Count(col2)>1);
returns:
col2 | CountOfCol2 | MinOfID<br />
pink | 2 | 5<br />
red | 4 | 1<br />
So you need to build another instructions to update your table using data returned by previous instruction.
I'm not sure which column is grouping column, so i can't help you more.