使用GROUP BY 查询表里面Z、X、和IsEmpty = 0 的出现次数
SELECT
Z AS Locate_Z,
X AS Locate_X,
Laneway,
COUNT (*) AS Number
FROM
Table_A
WHERE
IsEmpty = '0'
GROUP BY
Z,
X,
Laneway
再次附加在 Table_A 里面
SELECT *
FROM
WCS_LOCATE A
JOIN (
SELECT
Z AS Locate_Z,X AS Locate_X,Laneway AS Locate_Laneway
COUNT (*) AS Number
FROM
WCS_LOCATE
WHERE
IsEmpty = '0'
GROUP BY
Z,X,Laneway
) B ON A.X = B.Locate_X
AND A.Z = B.Locate_Z
由于Z,X,Laneway重复所以将Z,X,Laneway更换名字生成一张新表