Learning › Ecsqlreference › GROUPBY
Edit this page

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

ClassName InstanceCount
BisCore:DrawingCategory 328
BisCore:AnnotationTextStyle 22
BisCore:AuxCoordSystem2d 2s

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

ClassName InstanceCount
BisCore:DrawingCategory 328
BisCore:AnnotationTextStyle 22
BisCore:CategorySelector 313

ECSql Syntax

Last Updated: 29 April, 2025