sql find out record one-to-one

来源:互联网 发布:acg音乐知乎 编辑:程序博客网 时间:2024/05/19 16:49

one case can has multiple classes 

case : class = 1:n

find out the case number which has only one class.


select * from hm.[Class] where CaseFK in(select CaseFK clsCount from hm.[Class] group by CaseFK having count(ClassNbr) < 2 )


原创粉丝点击