Subject | Re: Problem creating UNIQUE index.. |
---|---|
Author | mk_delphi |
Post date | 2002-11-12T11:20:17Z |
Yes is empty, Thx Arno...
--- In ib-support@y..., "Arno Brinkman" <firebird@a...> wrote:
> Hi,
>
> > select BARCODE,NR_ORDINE,COUNT(*) from BARCODE
> > GROUP BY BARCODE,NR_ORDINE
> >
> > the index is : BARCODE,NR_ORDINE
> >
> > Can someone help me?
>
> The result of :
>
> SELECT
> BARCODE,
> NR_ORDINE,
> COUNT(*)
> FROM
> BARCODE
> GROUP BY
> BARCODE,
> NR_ORDINE
> HAVING
> COUNT(*) > 1
>
> is empty ?
>
> Regards,
> Arno