|Subject||Re: [firebird-support] Using COUNT(*)|
> I want to use Count(*) in my Select Statement with other fieldsselect field1, count(*) from table1 group by field1
> eg. Select Field1, Count(*) FROM TABLE 1
> but I keep getting a Dynamic SQL Error : Invalid column reference onYou should take some time and learn SQL. You will benefit from it later.
> line 1.....
> If I take the Count(*) out it works fine. This also applies to all
> Aggregate functions SUM, AVE etc.
> Anybody got an Idea?