Clone Order Detector :Find and Analyze Duplicate Customer Orders by Date and Amount Advanced

          with duplicates as
  (select customerid,
          orderid,
          orderdate,
          totalamount,
          row_number() over (partition by customerid,
                                          orderdate,
                                          totalamount
                             order by orderid) as rank
   from orders),
     is_duped as
  (select customerid,
          orderid,
          orderdate,
          totalamount
   from duplicates
   where rank > 1)
select o.*
from orders o
inner join is_duped i on o.customerid = i.customerid
and o.orderdate = i.orderdate
and o.totalamount = i.totalamount
order by o.customerid,
         o.orderid;