cred ca ceva de genul ....dar nu sunt sigur

select distinct A.LeadID,A.CompanyName from LeadBase A
join  LeadBase B on A.CompanyName = B.CompanyName and A.LeadID <> B.LeadID
where A.statecode = 0 and A.Companyname is not null
order by A.CompanyName asc