By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
3 rows affected
RowNum | Ops_Stat | RunID | Cust_ID | Name | DateTime | RowNum | RunID | Cust_ID | Name | Reason | DateTime | Status |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | U | A123 | AAA1111 | Hulk | 2019-09-01 01.05.01 | 2 | B456 | AAA1111 | Hulk | A | 2019-07-01 01.04.20 | Comp |
2 | U | B456 | AAA1111 | Hulk | 2019-07-01 01.04.11 | 2 | B456 | AAA1111 | Hulk | A | 2019-07-01 01.04.20 | Comp |
3 | U | C789 | AAA1111 | IronMan | 2019-05-01 01.03.01 | 2 | B456 | AAA1111 | Hulk | A | 2019-07-01 01.04.20 | Comp |
4 | A | D123 | AAA1111 | Spidey | 2019-01-01 01.02.01 | 2 | B456 | AAA1111 | Hulk | A | 2019-07-01 01.04.20 | Comp |
1 | U | A123 | AAA1111 | Hulk | 2019-09-01 01.05.01 | 3 | C789 | AAA1111 | Hulk | A | 2019-05-01 01.03.50 | Comp |
2 | U | B456 | AAA1111 | Hulk | 2019-07-01 01.04.11 | 3 | C789 | AAA1111 | Hulk | A | 2019-05-01 01.03.50 | Comp |
3 | U | C789 | AAA1111 | IronMan | 2019-05-01 01.03.01 | 3 | C789 | AAA1111 | Hulk | A | 2019-05-01 01.03.50 | Comp |
4 | A | D123 | AAA1111 | Spidey | 2019-01-01 01.02.01 | 3 | C789 | AAA1111 | Hulk | A | 2019-05-01 01.03.50 | Comp |