我在MySQL中有表,我正在try 过滤Cola中的数据并计算Colb中结果的实例,同时仍然获得所有匹配的行
表格名称:CityCityStuff
ColA | ColB | ColC |
---|---|---|
CityA | CityB | Other Stuff |
CityA | CityC | Other Stuff |
CityB | CityC | Other Stuff |
CityB | CityA | Other Stuff |
CityB | CityA | Other Stuff |
CityC | CityA | Other Stuff |
CityC | CityA | Other Stuff |
CityC | CityB | Other Stuff |
CityC | CityD | Other Stuff |
CityC | CityE | Other Stuff |
CityC | CityE | Other Stuff |
我想知道:
SELECT * FROM CityCityStuff WHERE ColA = 'CityC'
然后,在仍获得Cola=CityC的所有行的情况下,每个Colb重复多少次
返回的结果如下:
ColA | ColB | ColC | TotalEach |
---|---|---|---|
CityC | CityA | Other Stuff | 2 |
CityC | CityA | Other Stuff | 2 |
CityC | CityB | Other Stuff | 1 |
CityC | CityD | Other Stuff | 1 |
CityC | CityE | Other Stuff | 2 |
CityC | CityE | Other Stuff | 2 |
-哦,不.
ColA | ColB | ColC | TotalEach |
---|---|---|---|
CityC | CityA | Other Stuff | 2 |
CityC | CityA | Other Stuff | |
CityC | CityB | Other Stuff | 1 |
CityC | CityD | Other Stuff | 1 |
CityC | CityE | Other Stuff | 2 |
CityC | CityE | Other Stuff |