I have a table with a column named
Type that can have some set of values. For instance, A, B, C, D, etc. Behind the scenes this is mapped to an Enum.
I need to query this table to get a percentage of some subset of the values.
For example, I may want to get 400 total rows where 25 percent are
Type = 'A', 25 percent are
Type = 'B', and 50 percent are 'Type = 'C'
. If the total quantity of rows is not 400 it should return up to 400. Ideally, this would return 100A
rows and 200C` rows.
Or, perhaps, I want 100 rows where 50 percent are
A and 50 percent are
If it makes the query easier to write, I can pass in a count of each value I want instead of percentage, e.g.: 200 of A, 200 of C.
What is the best way to perform this query?