表A
A_1 A_2 A_3
1 name er
2 name fgda
3 name fdds
4 DDDD gertd
5 DDDD gdgdad表B
B_1 B_A_1 B_2 B_3
1 1 dfgd gfsf
2 2 dd gfio
3 4 fdg frere
4 5 dfrgr grido
5 2 dsfdf grfrg
6 4 dffdg dgfgf表A中A_1=B_A_1
现在我想获得表B中按A_2分组B_A_1重复值。
如现在就是name 1
DDDD 1
请大家帮忙。谢谢呢!!
A_1 A_2 A_3
1 name er
2 name fgda
3 name fdds
4 DDDD gertd
5 DDDD gdgdad表B
B_1 B_A_1 B_2 B_3
1 1 dfgd gfsf
2 2 dd gfio
3 4 fdg frere
4 5 dfrgr grido
5 2 dsfdf grfrg
6 4 dffdg dgfgf表A中A_1=B_A_1
现在我想获得表B中按A_2分组B_A_1重复值。
如现在就是name 1
DDDD 1
请大家帮忙。谢谢呢!!
from A, B
where A_1 = B_A_1
group by A_2, B_A_1
having count(B_A_1) > 1
select B_A_1,count(*)-1
from A, B
where A_1 = B_A_1
group by B_A_1
having count(*) > 1