easy5 pts · first answer countswindow-functionssqldata-cleaning

Deleting duplicate rows

A staging table has repeated rows for the same order_id. Which pattern keeps one row per order_id?

A.Number rows per order_id with ROW_NUMBER and keep rn = 1B.Rank rows over the whole table with RANK and keep rank = 1C.Add COUNT(*) per order_id and keep rows where it is 1D.Use LAG(order_id) and keep rows where it is NULL

Discussion 0

Join free to post in the discussion.

Deleting duplicate rows

Discussion 0

Related questions