Clone Order Detector
Tables Used
orders
ColumnType
orderidbigint
customeridbigint
orderdatetimestamp without time zone
totalamountdouble precision
statustext
Expected Output
Column
customerid
orderid
orderdate
totalamount

22. Clone Order Detector

Identify duplicate orders by customer, date, and total ... and assign row numbers.

Xorthax suspects duplicate orders. Write a query to identify all duplicate orders for the same customer with the same total amount and order date. Assign a unique row number to each duplicate.
Write Your Query