Community Remove duplicate from APEX collection by SSWUG Research (Scott Wesley) One of my favourite SQL analytic functions is row_number(), and I’ve used it in the past to identify, then remove duplicates. Register to Read