I have a database that contains thousands of records and the records are sorted by provider and there are only 300 of these. For audit purposes I need to extract a random 5 record sampling from each provider. In the event the provider does not have 5 records it would pull what it does have. I am sure there is a way to get this accomplished but my sql skills are a little rusty. Any help would be greatly apprecciated.
