Hi .. I need to find a way to identify which PLACES are repeated in each SEQ_ITEM_GUIA among the 7 columns. I inform you that this table has 2.5 million lines.
SEQ_ITEM_GUIA
Placa_1
Placa2
Placa_3
Placa_4
Placa_5
Placa_6
Placa_7
59016084
NEA4541
-
NEA4400
-
NEA4444
NEF0478
-
59016085
NEA4456
-
NEA4541
NEA4456
-
NEF0477
NEF0455
59016086
NEA4400
NEF0477
-
NEA4400
-
NEF0463
-
59016087
NEA4444
-
NEA4444
NEA4444
-
NEF0455
-
Thanks
Note. I'm Brazilian, my writing is not good. But my reading is very good.
