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 |