duplicate data - prayagupa/rdb GitHub Wiki

create or replace table `my_table` as
(
        SELECT * FROM (
          placement_views_dups AS (
            SELECT 
              pl.placement_id,
              pl.visitor_id,
              pg.timestamp
              ROW_NUMBER() OVER (PARTITION BY pg.visitor_id, pl.placement_id 
                                     ORDER BY pg.visitor_id, pl.placement_id) dup_id --assign dup_id to n joined rows
            FROM `placement_views` pl
            JOIN `page_views` pg
            ON pl.visitor_id = page.visitor_id
          ) SELECT * except(dup_id) FROM placement_views_dups WHERE dup_id in ( 1 )
        )
)