By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
| ITEM | COUNT(*) |
|---|---|
| CCC3333 | 1 |
| AAA1 | 4 |
| XXY427 | 1 |
| ABCRM10 | 1 |
| ABCLX283 | 1 |
| BBBB222 | 1 |
4 rows affected
| ITEM | COUNT(*) |
|---|---|
| CCC3333 | 1 |
| AAA1 | 4 |
| XXY427 | 1 |
| ABCRM10 | 1 |
| ABCLX283 | 1 |
| BBBB222 | 1 |