vendredi 8 mai 2015

Is there a name for aggregation queries that record '0' values?

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