By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| ordervehiclekey | orderkey | vehiclekey | orderhash | orderamt | agentemployee |
|---|---|---|---|---|---|
| 111 | ABC | 1 | AAA | 5000 | Doe |
| 111 | ABC | 1 | XXX | 2000 | Doe |
| 111 | ABC | 1 | YYY | 5000 | Smith |
| 111 | ABC | 1 | ZZZ | 3000 | Smith |
| 222 | ABC | 1 | AAA | 5000 | Doe |
| 222 | ABC | 1 | YYY | 5000 | Smith |