How to find assets with multiple categories of a schema?

We have a requirement in which we want to fetch all assets having more than one category from a particular schema. For e.g. we have a schema named "xyz" and it has 5 categories a, b, c, d and e. Now we need to find out which all assets  in repository have more than one category out of a, b, c, d and e. We want all assets which contains any possible combination of these 5 categories. E.g. assets having categories a and b or a and c or a,b, and c, etc.
Is it possible to find out this using any DB query or using APIs otherwise any simple way of doing this using Web Client?