sql find out record one-to-one
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 )