RE: Selecting doubles in a table and setting all but the first

2006-05-23 Thread Neeraj
Neeraj Black Bits _ From: Ruben Goethals [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 8:54 PM To: mysql@lists.mysql.com Subject: Selecting doubles in a table and setting all but the first Hi, everyone, This is something I can't seem to solve. Does anyone

Selecting doubles in a table and setting all but the first

2006-05-23 Thread Ruben Goethals
Hi, everyone,   This is something I can't seem to solve.  Does anyone know how to do this ?   I don't know whether I described this right.  Anyhow, jumping right in,  I have the following query which gives me all the LicenseNumbers that have a different Host-ID, but the same packageID (and w