--- In ib-support@y..., alfredm80@h... wrote:

> Hello:
>
> I have problems with the this select-sql statement:
>
> select * from dgcb group by numero order by numero;
>

Hi, Alfred. May I ask you what you want to group by here around
numero values? :) Group by is used with aggregates, such as

Select Customer, Count(*)
From Invoices
Group By Customer

to know how many invoices were linked with every customer, or

Select Customer, Sum(MoneyPaid)
From Invoices
Group By Customer

to know how much money every customer bringed us.

Best regards.