Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Eliminating reversed duplicate rows
Thanks markros. Worked great. Regards, Ray- raynalb
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Eliminating reversed duplicate rows
My SQL is a little rusty. Suppose I have Table1 with fields X and Y: X Y -- -- A B A C B A How would I write the SQL to eliminate the 3rd row because it is a duplicate of the 1st row when reversed? Thanks, Ray- raynalb
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
