select t.*,t.rowid from repaymentfrz t where t.batchno in (select t.batchno from repaymentfrz t where t.batchno IS NOT NULL group by batchno);