By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| name | year |
|---|---|
| aaa | 2010 |
| aaa | 2011 |
| aaa | 2012 |
| aaa | 2013 |
| aaa | null |
| bbb | 2000 |
| bbb | 2001 |
| bbb | 2002 |
| bbb | 2003 |
| bbb | null |
| name | year |
|---|---|
| aaa | 2010 |
| aaa | 2011 |
| aaa | 2012 |
| aaa | 2013 |
| aaa | 2014 |
| bbb | 2000 |
| bbb | 2001 |
| bbb | 2002 |
| bbb | 2003 |
| bbb | 2004 |
Warning: Null value is eliminated by an aggregate or other SET operation.