Subject RE: [firebird-support] Simple SQL question
Author Sasha
> I would have done it like this:
> Select t1.Field1, t1.Field2, SUM(t1.Field3),
> (select count(*) from table1 t2) as totalcount
> from t1.Table1
> Group by 1,2
That's not the same query, you're retrieving row count from table1, the
original query wants row count on a set based on table1.