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.


Mime
View raw message