计算行数据并选择它们

Question

下面是我在表'myTable'中设置的内容:

<表类> 公司 pointX 尖 tbody><<tr>微软12.43476.810亚马逊1.779290.122苹果601.840333.910

使用自连接:

SELECT t1.COMPANY,
ABS(t2.pointX - t1.pointX) + ABS(t2.pointY - t1.pointY) DISTANCE
FROM myTable t1 INNER JOIN myTable t2
ON t2.COMPANY <> t1.COMPANY
WHERE t2.COMPANY = 'Carlos';