Hi,
i want to delete some entries from a table. The table looks as follows:

Title:

- key long,
- name String,

the key is different for every entry in the table, but now i want to delete all rows with the same name ( 1 row of each title.name should be left over)!

would it be better to add a unique constraint to "name" ?

is it possible to delete them on a database level like:

delete from Title using Title title1, t2 where title1.name = title2.name

I know, it would be easy to check this on a java-level but at this time it tooks too much time!

thanks in advance
gerb