On Monday 22 September 2003 13:57, Becker, Holger wrote:
> Hermann Himmelbauer wrote:
> > ... and the SQL-Command like this:
> >
> > create unique index m1 on movie(imdbno)
> >
> > ... this leads to the following error:
> >
> > [SAP AG][LIBSQLOD SO][SAP DB]Integrity constraint
> > violation;250 POS(1)
> > Duplicate secondary key.
>
> Hi,
>
> The error 250 means that the column imdbno includes non unique data.
> "select imdbno from movie group by imdbno having count(movieid) > 2"
> should return such rows.
Thank you a lot, this was the solution...
Best Regards,
Hermann
--
[EMAIL PROTECTED]
GPG key ID: 299893C7 (on keyservers)
FP: 0124 2584 8809 EF2A DBF9 4902 64B4 D16B 2998 93C7
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
