db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Amir Michail" <amich...@gmail.com>
Subject how to suppress similar rows while copying from one table to another?
Date Fri, 16 Nov 2007 01:02:29 GMT

I would like to copy rows from one table to another while copying
only the first row from sets of similar rows.

In particular, for rows in which two particular fields are the same, I would
like to copy only the first row in that set.  The rows have more than these
two fields.

I know how to copy rows from one table to another, but how do I suppress
similar rows in this way?


View raw message