Posted by Jeff Kish on 10/01/74 11:28

hi.
I've seen ways to delete duplicate rows.
Can someone give me some sql to do this?

I have a table with varchar table_name_start, varchar column_name,
varchar table_name_end;

it has rows like this:
table1 col1 table2
table1 col2 table 3
table2 col1 table1

I'd lke to delete the rows if they exist with the names swapped
around, i.e. like above since the first and third share a column name
and the table_name_start/end matches the others table_name_end/start,
I'd like to delete one and leave the other.

I'm scratching my head trying to figure this out.

thanks

• Next in forum: Please suggest backup software
• Prev in forum: Re: Security Admin on a server with NO public permissions
• Thread view: delete of mirrored rows

[Reply to this message]