Hello,
Please try below query:
select ContactID,SchoolID,COUNT(ContactID) as DuplicateNumbers from WorkingGroupSchoolContact
group by ContactID,SchoolID
Having COUNT(ContactID) > 1
This query will return all the duplicate records in the combination of ContactID and SchoolID.
Please let me know if you have any concern or query on this or if I am missing something.
Thanks