By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| N_GROUP | N_SORT | N_NAME |
|---|---|---|
| aa | 1 | pr_1 |
| aa | 1 | pr_1 |
| aa | 1 | pr_1 |
| aa | 1 | pr_1 |
| aa | 1 | pr_1 |
| bb | 1 | pr_1 |
| bb | 2 | pr_2 |
| bb | 1 | pr_1 |
| bb | 2 | pr_2 |
| bb | 1 | pr_1 |
| cc | 1 | pr_4 |
| cc | 2 | pr_8 |
| cc | 3 | pr_9 |
| cc | 1 | pr_4 |
| cc | 2 | pr_8 |