I have around the following example:
123456789 ;9876 ;654
123456789; 9876 ; 654
so the problem is that I have around 13 million records like that and I want to grab only the one record out of those records which is:
in example data I have put SPACES myself which means the data in table have spaces, the accountnumber
unique although some have spaces either before or after which is correct for other two as well, so based on that example I would like to have query to grab the first record and leaving others behind even if it has space or different newaccount or oldaccount for me it does not matter as long as I get unique acccountnumber with oldaccount and newaccount whichever it would be from the list.
so what i'm looking for the result is: