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

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