select field1 from table group by field1 having count(field1) > 1
while select count(recId), field1 from table group by field1 { if (table.recId > 1) {