Select only 1 value out of a range for mapping purposes
I have a table out of which I'd like to create a mapping table. Problem is however that for now, there is no 1 to 1 mapping possible. For every 'identifier' in the table, there can be 1 or more MOAR's.
As the information between MOARs is similar (result of a multiplication earlier on in the process which I cannot change), I can afford to drop them, and only keep 1 per identifier. My question now is how to reduce the MOAR's so that for every identifier, I only keep 1 MOAR out of 1/2/3/.....