Q1.2
Anonymous
pgsql
07/01/2022 6:22 PM
460 B
23
Indexable
select
customer_id, hit_day, page_asin
from
(select *,
row_number() over( partition by customer_id
order by
hit_day desc,
hit_datetime_utc) as row_n
from
Clickstream) as clickdata
where
row_n = 1Editor is loading...