removing rows with a duplicate column in SQL?

[RobertSK]

Hello, is there a way to remove rows that contain duplicate data in a specific row.

For example, Table A has columns X, Y, Z.
if a few entries were like:

1, 2, 3
g, v, d
6, 5, 3
7, 5, 5
4, 3, 3

As you can see, in column Z, 3 appears three times. Is there a way to delete two of them? (does not matter which one is left).
This is only a simplified example, in reality there are four-five columns that must be unique like this.

If there is a SELECT statement that could produce these results that would work too!

Thanks in advance

[Drakla]

Have you got a unique ID for any of your columns - a primary key? If so and your primary key was id and the table mytable you could do it with

DELETE t2 FROM mytable as t1, mytable as t2 WHERE t1.col3 = t2.col3 AND t1.id != t2.id

No primary id means more work

[RobertSK]

worked like a charm =)
thank you very much!

[Drakla]

No probs. At the top of the page, just on the right where the thread starts is "Thread Tools", if you get your problem solved the mark the thread as resolved so people can help elsewhere.

Cheers.