Subject Re[2]: [ib-support] Select Count(*) strange Result
Author Dieter Tremel
Hello Arno,

at Dienstag, 17. Dezember 2002, 14:45 you wrote:

> Count(*) returns the number of rows that are "grouped". In your case the
> number of distinct rows from WBG.VERKAUFSKONTO and A.UMSATZSTEUERCODE. Add
> to Count(*) to your first query and you'll see.

thank you, of course that is right. It was not my idea but the
strategy behind IBObjects Recordcount method for this query. I was
analyzing it because of the unexpected result.

But how can I determine the number of record after grouping? Fetching
all in a while loop? As I often recognize, SQL is so easy in the books
but not so easy, when solving real worlds queries. ;-)