By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
12 rows affected
| COL | ABBR |
|---|---|
| AAA | AAA |
| AAAAAA | AAAA |
| AABA | AAB |
| AB | AB |
| AC1 | AC |
| AD | AD |
| BAAAA | BA |
| BBAA | BB |
| COL1 | COL1 |
| COL21 | COL2 |
| Y | Y |
| ZC | Z |
12 rows affected
| COL | ABBR |
|---|---|
| AAA | AAA |
| AAAAAA | AAAA |
| AABA | AAB |
| AB | AB |
| AC1 | AC |
| AD | AD |
| BAAAA | BA |
| BBAA | BB |
| COL1 | COL1 |
| COL21 | COL2 |
| Y | Y |
| ZC | Z |