count distinct 

select PaidInID,count(distinct SignInstitutionName) from PI_PaidInMonthlyEmployeeExtra
group by PaidInID
having count(distinct SignInstitutionName) > 1

 

posted @ 2020-12-01 17:36  江境纣州  阅读(17)  评论(0)    收藏  举报