Subject | Re: [ib-support] Problem creating UNIQUE index.. |
---|---|
Author | Arno Brinkman |
Post date | 2002-11-12T11:13:24Z |
Hi,
SELECT
BARCODE,
NR_ORDINE,
COUNT(*)
FROM
BARCODE
GROUP BY
BARCODE,
NR_ORDINE
HAVING
COUNT(*) > 1
is empty ?
Regards,
Arno
> select BARCODE,NR_ORDINE,COUNT(*) from BARCODEThe result of :
> GROUP BY BARCODE,NR_ORDINE
>
> the index is : BARCODE,NR_ORDINE
>
> Can someone help me?
SELECT
BARCODE,
NR_ORDINE,
COUNT(*)
FROM
BARCODE
GROUP BY
BARCODE,
NR_ORDINE
HAVING
COUNT(*) > 1
is empty ?
Regards,
Arno