43. 根据某个字段查询的重复的记录，例：查testId重复的记录

select t.* from test t    
where t.testId in (select testIdfrom test group by testIdhaving count(testId) > 1);