Recent content by Teki07

They both work if I run them separate but once I joined them with the minus. i just tried to excute for a long time and it hangs

no, the fist one SELECT a.column1, b.column1 FROM table1 a, table1 b WHERE REPLACE (a.column1, ' ', '') = REPLACE (b.column1, ' ', '') MINUS SELECT a.column1, b.column1 FROM table1 a, table1 b WHERE a.column1 <> b.column1

Turkbear, Thank you for the suggestion but it did not work the sql did not execute. :(

To explain a little bit better the results, I need to find the duplicate records due to spacing so it can be fix in the database so I want to see record 1 which is AB has a duplication due to spacing, that record is A B. I need to see both so I am comparing the same column. Once I compare I...

SantaMufasa, Thank you but I think I did not explain myself right. I have a table with a row that must be unique. However, some of the records have spacing on it which does not make it unique. I created the first query to find out the duplicated records due to spacing. My results from my...

Hi, I have a query that finds any duplicates caused by spacing. This is my query Select a.column1, b column1 from table1 as a, table1 as b where replace (a.column1,' ','') = replace (b.column1,' ','') and a.column1 &lt;&gt; b.column1 this is my result column1 column1_1 A+ A + A + A+ B+ B + B...