By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| subscription_id | id | os | created_at | rn | id | channel | trx_date |
|---|---|---|---|---|---|---|---|
| sub890 | 123 | mac | 01/01/2019 05:00:01 | 1 | 123 | organic | 01/01/2019 05:00:00 |
| sub111 | 987 | windows | 01/01/2019 10:00:01 | 1 | 987 | add | 01/01/2019 10:00:00 |