How to remove duplicate rows from a temp table

[dbrewerton]

Hello experts, I'm needing some help trying to remove duplicated records from my table. What I mean by duplicated records is they are complimentary records where I have two numbers and these same two numbers get reversed. I'd like to have only one or the other, not both. Here is what the table looks like:

num1    Owner1    Start1    End1    Descr1                                    num2    Owner2    Start2    End2    Descr2
123456    John Doe    0:00:00    3:00:00    Reboot Systems                    234567    John Doe    0:00:00    3:00:00    Install Memory
123456    John Doe    0:00:00    3:00:00    Reboot Systems                    345678    John Doe    0:00:00    3:00:00    Resolve issue with TCPIP packets
234567    John Doe    0:00:00    3:00:00    Install Memory                    123456    John Doe    0:00:00    3:00:00    Reboot Systems
234567    John Doe    0:00:00    3:00:00    Install Memory                    345678    John Doe    0:00:00    3:00:00    Resolve issue with TCPIP packets
345678    John Doe    0:00:00    3:00:00    Resolve issue with TCPIP packets    123456    John Doe    0:00:00    3:00:00    Reboot Systems
345678    John Doe    0:00:00    3:00:00    Resolve issue with TCPIP packets    234567    John Doe    0:00:00    3:00:00    Install Memory
345678    John Doe    0:00:00    3:00:00    Resolve issue with TCPIP packets    456789    John Doe    0:00:00    2:00:00    Reinstall Java Applets
456789    John Doe    0:00:00    2:00:00    Reinstall Java Applets                    345678    John Doe    0:00:00    3:00:00    Resolve issue with TCPIP packets
 

As you can see, I have a bit of a perdicament here. Sometimes, I can have as few as one record being duplicated. In my case, num1 and num2 with all its information gets duplicated.

[Rabbit]

You will need to add an identity field if you don't already have one.

Then you can use a subquery to select everything except either the min or the max to delete.

Afterwards you can drop the identity field.