56,687
社区成员
发帖
与我相关
我的任务
分享
Select english,address,po1,po2,Count(*) From A Group By english Having Count(*) > 1
Select english,address,po1,po2,Count(*) From table1 Group By english Having Count(*) > 1
列出:
english address po1 po2 Count(*)
101 Thai Kitchen 352 King Street W6 0RX 2
Abokado 63 Cowcross Street EC1M 6BP 2
Addie's 121 EarlCourt Road SW5 9RL 2
...
可以看到101 Thai Kitchen是有重复的,两个, Abokado也有两个重复,Addie也有两个重复。
需要得到这样的表:
101 Thai Kitchen 352 King Street W6 0RX
101 Thai Kitchen 352 King Street W6 0RX
Abokado 63 Cowcross Street EC1M 6BP
Abokado 40-56 City Road EC1Y 2AN
Addie's 121 EarlCourt Road SW5 9RL
Addie's 121 EarlCourt Road SW5 9RL
...
也就是列出所有重复的,不知道这样版主明白了没有呢?