Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
128 B
2
Indexable
Never
SELECT * ,
RANK() OVER (partition by user_id ORDER BY CAST(event_time as date) DESC) 
from tools_shop.events
ORDER by user_id