WITH ranked AS (
SELECT *, ROW_NUMBER() OVER (
PARTITION BY user_id ORDER BY timestamp DESC
) AS rn
FROM cs_reward_point_changes
)
SELECT user_id,
CASE WHEN timestamp < DATEADD(day,-500,GETDATE())
THEN 0 ELSE amount END AS amount,
timestamp
FROM ranked WHERE rn = 1;Page created in 0.024 seconds with 9 queries.