By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
10 rows affected
| ID | Col1 | Col2 | Required_result |
|---|---|---|---|
| 1 | pencil red | charcoal, pencil, scale | charcoal, scale |
| 2 | pencil red | charcoal, red, scale | charcoal, scale |
| 3 | ball pen | eraser, pen | eraser |
| 4 | ball pen | ball, box | box |
| 5 | ball pen | eraser, ball pen | eraser |
| 6 | ball pen | eraser, pen ball | eraser |
| 7 | ball pen | eraser, watercan, bag | eraser, watercan, bag |
| 8 | Note book | Note book | |
| 9 | Note book | Note book, eraser | eraser |
| 10 | Note book |