I haven't tested but the following should work.
SELECT COUNT(*) FROM (
Select
Field1,
Field2,
SUM(Field3)
from Table1
Group by 1,2
)

Regards
Yusuf

________________________________

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Michael
Vilhelmsen
Sent: Tuesday, July 17, 2007 10:47 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Simple SQL question



Hi

I have a rutine in which I would like to have a progressbar.

The SQL is like this:

Select
Field1,
Field2,
SUM(Field3)
from Table1
Group by 1,2

I would like to be able to count how many records there will be
returned to me by this SQL.

Can I do that ?

Regards Michael






[Non-text portions of this message have been removed]