SQL Query single bank account repeat

Not one unit more bank account.

Today Chengdu company Xiangjiao payment when the unit name in the pop-up net silver to 1, from the bank to see is normal, just in the molecular group of Companies click Modify Bank save on the prompt error "bank account cannot be repeated"

Select *  from  Select bankacc,bankname,pk_accbank,unitname,ts,Count(pk_accbank)over by     from Bd_accbank)  where R>= 2 

Sure enough there was this problem.

When I do, I use SUM (pk_accbank) over (partition by BANKACC), and then the error ORA-01722 Invalid number

Ask the group of Chen Hai, is the sum of the column has a problem, I summed up the numbers.

Low-level error, using Count

SQL Query single bank account repeat