By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| name1 | name2 | year1 | year2 |
|---|---|---|---|
| apple | null | 2009 | 2005 |
| apple | grape | 2010 | 2008 |
| apple | pear | 2010 | 2001 |
| apple | pear | 2011 | 2002 |
| pear | orange | 2008 | 2006 |
8 rows affected
| name1 | name2 | year1 | year2 |
|---|---|---|---|
| apple | null | 2009 | 2005 |
| apple | grape | 2010 | 2008 |
| apple | pear | 2010 | 2001 |
| apple | pear | 2011 | 2002 |
| pear | orange | 2008 | 2006 |