Q1.2
unknown
pgsql
3 years ago
344 B
13
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...