By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
10 rows affected
| cityid | storeid | deviceid | tags |
|---|---|---|---|
| 1234 | 101 | 5 | Online |
| 1234 | 101 | 5 | InActive |
| 1234 | 101 | 6 | Online |
| 1234 | 101 | 6 | InActive |
10 rows affected
| cityid | storeid | deviceid | tags |
|---|---|---|---|
| 1234 | 101 | 5 | Online |
| 1234 | 101 | 5 | InActive |
| 1234 | 101 | 6 | Online |
| 1234 | 101 | 6 | InActive |