I see questions all the time (and perhaps a Meta post could be made about how to handle them) that follow the lines of:
Get the count of [some field] for [some object].
Where the problem usually lies in:
SELECT myField, COUNT(*)
FROM myTable
GROUP BY myField;
Which will not return rows that have 0 counts, so it typically involves preforming an outer join back to the table to get those counts.
Is there a name for this type of procedure? Is it still just simply Aggregation
? The reason I wonder if it's different, is because it involves using a join to aggregate data that doesn't exist in the table.
Also, I have heard of special types of aggregation such as conditional aggregation
, so I thought there might be a term [slang, or standard] for this type of operation.
Aucun commentaire:
Enregistrer un commentaire