Subject Re: [firebird-support] Using COUNT(*)
Author Milan Babuskov
quinton_marks wrote:
> I want to use Count(*) in my Select Statement with other fields
> eg. Select Field1, Count(*) FROM TABLE 1

select field1, count(*) from table1 group by field1

> but I keep getting a Dynamic SQL Error : Invalid column reference on
> 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?

You should take some time and learn SQL. You will benefit from it later.

Milan Babuskov