Skip to content

Instantly share code, notes, and snippets.

@javrasya

javrasya/select-last-value.sql

Last active December 27, 2019 13:33
Show Gist options
  • Save javrasya/0d1230c48e2d72dddb076d39c20eaad5 to your computer and use it in GitHub Desktop.
Save javrasya/0d1230c48e2d72dddb076d39c20eaad5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
select-last-value.sql
select
user_id,
LAST_VALUE(location)over w,
event_time
from my_users
window as (user_id by category order by event_time)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment