How can I do a FULL OUTER JOIN in MySQL

Remove duplicate values in different columns Oracle SQL

Bianchi

assuming I have a table with 18 columns and i wantto remove from the table rows that are duplicate but in different columns (leaving just 1 row from the duplicate ones)

for exampel :

ID'S MEMBER 1 MEMBER 2 MEMBER 3 MEMBER 4 x1,x2,x3,X4 x1 x2 x3 x4 x2,x3,x1,x4 x2 x3 x1 x4 x1,x4,x3,x2 x1 x4 x3 x2

will become

ID'S MEMBER 1 MEMBER 2 MEMBER 3 MEMBER 4 x1,x2,x3,X4 x1 x2 x3 x4

for example (of 4 cells and I have 18 )