mysql 行比较_mysql – 如何比较表中的每一行与所有行？

我正在使用

mysql.

将每一行与此表中的所有左行进行比较,并选择HEADING介于-15

myTable

id

heading (In degrees)

timestamp (in seconds)

例如.第一个表行：

1 - 50 - 133324565

2 - 12 - 133324565

3 - 10 - 133324565

5 - 220 - 133324565

6 - 35 - 133324565

10 - 10 - 133324565

11 - 15 - 133324565

12 - 22 - 133324565

16 - 168 - 133324565

如你所见,ID不是顺序的,所以我不能这样做吗？

SELECT T1.id,T1.heading,T2.id,T2.heading

FROM mytable as T1, mytable as T2

WHERE T1.id > T2.id -1

AND (T1.timestamp > T2.timestamp -10 OR T1.timestamp < T2.timestamp +10)

AND (T1.heading > T2.heading -15 OR T1.heading < T2.heading +15)