Find duplicate name partner in iDempiere

select
    A.*
from
(
    select bp.*, COUNT(*) OVER(PARTITION BY bp.name) N from c_bpartner bp
    where bp.ad_client_id = 1000000
) as A
where N > 1