select * from lims_sample_programs where (criterionid) in
(select criterionid from lims_sample_programs group by criterionid having count(criterionid) >1)
and rowid not in (select min(rowid) from lims_sample_programs group by criterionid having count(criterionid)>1) order by criterionid;