By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| CLIENT | max order date | 2nd highest max ord.date |
|---|---|---|
| 1 | 01-FEB-19 | 14-SEP-18 |
| 2 | 01-JAN-20 | 15-DEC-19 |
| CLIENT | max order date | 2nd highest max ord.date |
|---|---|---|
| 1 | 01-FEB-19 | 14-SEP-18 |
| 2 | 01-JAN-20 | 15-DEC-19 |