By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
11 rows affected
| id | sender | last_login_date |
|---|---|---|
| 1 | {"lastName": "Ivanov", "firstName": "Ivan", "middleName": "Ivanovich"} | 2021-04-10 14:49:36.234504 |
| 2 | {"lastName": "Ivanov", "firstName": "Ivan", "middleName": "Ivanovich"} | 2021-04-09 14:49:36.234504 |
| 3 | {"lastName": "Ivanov", "firstName": "Ivan", "middleName": "Ivanovich"} | 2021-04-11 14:49:36.234504 |
| 4 | {"lastName": "Nickov", "firstName": "Nickolai", "middleName": "Nikovich"} | 2021-04-30 14:49:36.234504 |
| 5 | {"lastName": "Nickov", "firstName": "Nickolai", "middleName": "Nikovich"} | 2021-04-29 14:49:36.234504 |
| 6 | {"lastName": "Vladimirovich", "firstName": "Vladimir", "middleName": "Putout"} | 2021-04-15 14:49:36.234504 |
| 7 | {"lastName": "Petrov", "firstName": "Petr", "middleName": "Petrovich"} | 2021-04-10 14:49:36.234504 |
| 8 | {"lastName": "Ivanov", "firstName": "Ivan", "middleName": "Ivanovich"} | 2021-04-01 14:49:36.234504 |
| 9 | {"lastName": "Ignatov", "firstName": "Ignat", "middleName": "Ignatovich"} | 2021-04-06 14:49:36.234504 |
| 10 | {"lastName": "Vladimirovich", "firstName": "Vladimir", "middleName": "Putout"} | 2021-04-17 14:49:36.234504 |
| 11 | {"lastName": "Ivanov", "firstName": "Ivan", "middleName": "Ivanovich"} | 2021-04-12 14:49:36.234504 |
| id | sender | last_login_date | rn |
|---|---|---|---|
| 4 | {"lastName": "Nickov", "firstName": "Nickolai", "middleName": "Nikovich"} | 2021-04-30 14:49:36.234504 | 1 |
| 10 | {"lastName": "Vladimirovich", "firstName": "Vladimir", "middleName": "Putout"} | 2021-04-17 14:49:36.234504 | 1 |
| 11 | {"lastName": "Ivanov", "firstName": "Ivan", "middleName": "Ivanovich"} | 2021-04-12 14:49:36.234504 | 1 |
| 7 | {"lastName": "Petrov", "firstName": "Petr", "middleName": "Petrovich"} | 2021-04-10 14:49:36.234504 | 1 |
| 9 | {"lastName": "Ignatov", "firstName": "Ignat", "middleName": "Ignatovich"} | 2021-04-06 14:49:36.234504 | 1 |