GROUP BY clause

Syntax: GROUP BY <expr-list> [HAVING <group-filter-expr]

Count instances of each type of class.

Query

    SELECT EC_CLASSNAME([ECClassId]) [ClassName], COUNT(*) [InstanceCount]
    FROM [BisCore].[Element]
    GROUP BY [ECClassId]
    LIMIT 3

Result

Count instances of each type of class by filter out group with count less then 10.

Query

    SELECT EC_CLASSNAME([ECClassId]) [ClassName], COUNT(*) [InstanceCount]
    FROM [BisCore].[Element]
    GROUP BY [ECClassId]
    HAVING COUNT(*)>10
    LIMIT 3;

Result

ECSql Syntax