Sunday, July 31, 2022

Different Ogranaization

 Phone No used to register in Multiple organizations.


SELECT distinct l.PhoneNo FROM MemberPortal_Bulk l

INNER JOIN(

SELECT OrgID, PhoneNo,count(*) Noof 

FROM MemberPortal_Bulk group by OrgID, PhoneNo

having count(*)>1) noof on l.PhoneNo=noof.PhoneNo

where l.OrgID!=noof.OrgID

No comments:

Post a Comment

Screen Record

 Windows Screen Record WindowsKey+ Alt + R Recording Starts.