查询List中a重复的项
1、select a from List group by a having count(*) > 1
2、select * from list where a in (select a from List group by a having count(*) > 1)
3、select * from List where (select count(*) from List s where s.a = List.a) > 1
筛选分组之后的结果,使用having