Omitting duplicate values during search or sorting
is there a way to chuck away records with duplicate values during sorting or searches?
I'm making a report that should contain all the products ordered within a given month. I have a found set of ProductIDs from all the OrderItems in all Orders executed in the month. I want to get a list of products. For example, the set could look something like this
7, 9, 4, 1, 2, 9, 3, 4, 2, 5
and the result I need to achieve in a script, either by sorting or searching, or by combination of thereof, would be:
1, 2, 3, 4, 5, 7, 9
Should be pretty easy, right?