I would like to do the following in a formula:
SELECT count(dbA.a1)
WHERE dbA.a2 = 3 // any constant
i.e. to count number of occurences of a1 from dbA where from its attribute a2 equals a certain constant.
Unfortuantely cannot put the above into SQL Expression. Syntax errors and unable to compile.
Is there a way? Thanks for your help!
SELECT count(dbA.a1)
WHERE dbA.a2 = 3 // any constant
i.e. to count number of occurences of a1 from dbA where from its attribute a2 equals a certain constant.
Unfortuantely cannot put the above into SQL Expression. Syntax errors and unable to compile.
Is there a way? Thanks for your help!