数据如下:
ID A B
1 50 40
1 50 40
2 50 40
2 40 50
3 50 30
3 50 30
3 50 30
4 60 60
4 50 50
4 60 60
5 50 40
5 50 30
6 50 50
找出所有ID行数大于等于两行并且按ID分组组内的所有A和B全部相同的ID
期望的结果得到
ID
1
3
------解决思路----------------------
select id from test group by id having count(1)>1 and max(A)=min(A) and max(B)=min(B);