By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
11 rows affected
| row_id | agent_name | type_login_break | class | (No column name) |
|---|---|---|---|---|
| 7276541 | TrevorT | Login | 162 | 162 |
| 7276993 | TrevorT | Break | 0 | 162 |
| 7277421 | TrevorT | Break | 0 | 162 |
| 7278660 | TrevorT | Login | 106 | 106 |
| 7278754 | TrevorT | Login | 162 | 162 |
| 7279485 | TrevorT | Break | 0 | 162 |
| 7280372 | TrevorT | Login | 69 | 69 |
| 7280984 | TrevorT | Break | 0 | 69 |
| 7281135 | TrevorT | Login | 162 | 162 |
| 7282310 | TrevorT | Login | 162 | 162 |
| 7283716 | TrevorT | Break | 0 | 162 |
Warning: Null value is eliminated by an aggregate or other SET operation.