Suppose a query on the sales table does result in 100 records.
90% of the sales applies to only 10 customers (records) , the last 10% applies to 90 customers (records).
Now I want to summarize this 90 records to only 1 record with the name "Others".

- Is there a common name for this approach

- What would be the best approach ? (does someone have samples for it)

regards,

Rinse