By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ID | NO | DIA | YN |
|---|---|---|---|
| 3201-20210103001 | 1 | A | y |
| 3201-20210103001_002 | 1 | A | Y |
| 3201-20210103001 | 2 | A | y |
| 3201-20210103001_002 | 2 | B | Y |
| 3201-20210103001 | 2 | B | Y |
| 3201-210104001-ari | 1 | A | y |
| 3201-210104001_01 | 1 | A | N |
| 3201-210104001 | 1 | A | Y |
| 3201-210104001 | 1 | B | N |
| 3201-210104001_02 | 1 | B | N |
| 3201-210104003_03 | 1 | B | n |
| 3201-210104004_04 | 1 | B | Y |
| 3201-210104004_04 | 1 | B | Y |
| 3201-210104004_04 | 1 | B | y |
| 3201-210104004_04 | 1 | B | N |
| 3201-210104004_04 | 1 | B | y |
| 3201-210104004_04 | 1 | B | Y |
| 3201-210104004_04 | 1 | B | N |
| 3201-210104004_04 | 1 | B | n |
| ID | NO | DIA | YN |
|---|---|---|---|
| 3201-20210103001 | 1 | A | y |
| 3201-20210103001 | 2 | A | y |
| 3201-20210103001 | 2 | B | Y |
| 3201-210104001 | 1 | A | N |
| 3201-210104001 | 1 | B | N |
| 3201-210104003 | 1 | B | n |
| 3201-210104004 | 1 | B | N |