add remove split language show hidden hide
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
user_id value date
2 10000 2021-01-25 20:30:01
2 1314 2021-01-28 21:19:02
2 2323 2021-02-10 21:19:03
2 999 2021-03-01 16:30:04
2 444 2021-03-01 17:30:05
2 1000 2021-03-02 18:30:06
2 99 2021-03-02 18:33:07
2 44 2021-03-02 20:30:08
2 999 2021-03-03 18:28:09
2 99 2021-03-03 18:29:10
2 1100 2021-03-25 18:30:11
user_id value date rn cnt
2 1100 2021-03-25 18:30:11 11 2
2 99 2021-03-03 18:29:10 10 1
2 999 2021-03-03 18:28:09 9 1
2 44 2021-03-02 20:30:08 8 1
2 99 2021-03-02 18:33:07 7 1
2 1000 2021-03-02 18:30:06 6 1
2 444 2021-03-01 17:30:05 5 1
2 999 2021-03-01 16:30:04 4 1
2 2323 2021-02-10 21:19:03 3 3
2 1314 2021-01-28 21:19:02 2 2
2 10000 2021-01-25 20:30:01 1 1