db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Leechoo <leec...@o2.pl>
Subject Re: import with unique and identity column
Date Mon, 17 Dec 2007 11:52:05 GMT

Leechoo wrote:
> Maybe I would delete unique property from C2 column and delete duplicate
> rows after import. But how?
> Thanks for any help

This block of code enable delete all duplicate rows:

delete from TABLE as P1
where P1.id > 
             ( select min(P2.ID) from TABLE as P2
               where P1.col1= P2.col1); 

View this message in context: http://www.nabble.com/import-with-unique-and-identity-column-tp14159742p14370245.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

View raw message