Deleting duplicate rows

From: <tschwickert_at_nvag.de>
Date: Mon, 07 Dec 1998 13:22:34 GMT
Message-ID: <74gkqp$et7$1@nnrp1.dejanews.com>

Hi,

How can I delete lines appearing more than one time for some columns, eg.

COL1 COL2 COL3

1    a     dfgfdg
2    x      dfdsfs
1    a     oiiziz

Line 1 and 3 are identical for COL1 and COL2. I want to eliminate these lines.
Any ideas ?
(ok, I know how to get the lines which just occurs one, and than can insert these into a new table. But is there a way to really delete these lines ?)

Thanks in advance
 Thomas

--

Thomas Schwickert               Phone: +49 69 - 404 8661
Neckermann Versand AG           Fax:   +49 69 - 404 5561

60386 Frankfurt
Germany

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Dec 07 1998 - 07:22:34 CST