These will be repeated in the value of the field, and is all the same, such as:
A b c d
1, 2, 3, 4,
1 2 3 4
3 5 6 8
September 4 2 5
7 1 5 7
2 7 8 August
2 7 8 August
Want to get rid of after repeated is
A b c d
1 2 3 4
3 5 6 8
September 4 2 5
7 1 5 7
2 7 8 August
No distinct, how do I remove all duplicate values (delete), only keep the only?
CodePudding user response:
Select a, b, c, d from table group by a, b, c, d