Dear all

I have a table with 40'000 records. In there are records which have three or
more times the same ID. I need only one record of the same ID. How could I
delete the others by using a query?

Thank you for providing me with the appropriate solution.

With kind regards

C. Cattaneo

christian cattaneo
Bundesamt f�r Verkehr BAV
Bollwerk 27/29
CH-3003 Bern
e-mail: [EMAIL PROTECTED] oder
            [EMAIL PROTECTED]

tel: +41 31 325 12 78


---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 9544

Reply via email to