A short SQL snippet to find single records of different kind. For example one of each Clients that speak different languages.
Sample Process for a Batch Contact Deletion
SELECT Min(SubscriberKey) as SubscriberKey, Language
FROM [myDataExtension]
GROUP BY Language