Select * From bnk_trx ; Where bnk + chkno In (Select bnk + chkno From bnk_trx ; Group By bnk, chkno Having Count(*) > 1) And amt > 1