select * from B as b where b.BillNum in (select b.BillNum from B group by b.BillNum having count(1) > 1)