By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| RNUM | NAME | ADDRESS | MNAME | LNAME |
|---|---|---|---|---|
| 1 | John | Address1 | Carol | Cena |
| 1 | John | Address1 | Mark | Karlo |
| 1 | John | Address2 | Carol | Cena |
| 1 | John | Address2 | Mark | Karlo |
| RNUM | NAME | ADDRESS | MNAME | LNAME |
|---|---|---|---|---|
| 1 | John | Address1 | Carol | Cena |
| 1 | John | Address1 | Mark | Karlo |
| 1 | John | Address2 | Carol | Cena |
| 1 | John | Address2 | Mark | Karlo |