By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| orderno | custid | orderdt |
|---|---|---|
| A1001 | 1001 | 2020-01-15 00:00:00.000 |
| A1002 | 1001 | 2020-01-20 00:00:00.000 |
| A1003 | 1001 | 2020-01-30 00:00:00.000 |
| A1006 | 1006 | 2020-01-25 00:00:00.000 |
| A1007 | 1006 | 2020-01-27 00:00:00.000 |
| A1008 | 1006 | 2020-01-30 00:00:00.000 |