--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:

>
>
>
> > 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
>
> But it would different results, wouldn't it?

It would indeed be different.

Mihcael

>
> Martijn Tonies
> Database Workbench - development tool for Firebird and more!
> Upscene Productions
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
> > I haven't tested but the following should work.
> > SELECT COUNT(*) FROM (
> > Select
> > Field1,
> > Field2,
> > SUM(Field3)
> > from Table1
> > Group by 1,2
> > )
>