Untitled
Anonymous
plain_text
07/27/2023 6:42 PM
172 B
25
Indexable
SELECT * , RANK() OVER (partition by user_id ORDER BY CAST(event_time as date) DESC) from tools_shop.events ORDER by user_id
Editor is loading...
SELECT * , RANK() OVER (partition by user_id ORDER BY CAST(event_time as date) DESC) from tools_shop.events ORDER by user_id