By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | cont_no | max_date |
|---|---|---|
| 1 | 1 | 2017-03-22 |
| 2 | 1 | 2012-10-04 |
| 3 | 2 | 2011-01-08 |
| 4 | 1 | 2011-01-25 |
| id | cont_no | max_date |
|---|---|---|
| 1 | 1 | 2017-03-22 |
| 2 | 1 | 2012-10-04 |
| 3 | 2 | 2011-01-08 |
| 4 | 1 | 2011-01-25 |