A Gentle Introduction to

SQL

Deleted

Deleted tips


Select ?
I have GPS coordinates in my database and I wanna see that position is changed. table is ID,X,Y 1,22.33,11.22 must result nothing 2,22.32,11.22 must result stationary 3,22.33,11.22 must result stationary since difference is not big enough dx>0.01 and dy >0.01 4,22.33,11.22 must result stationary 5,22.37,11.19 must result moving 6,22.38,11.19 must result stationary
oracle variations:
None

access
db2
mysql
oracle
postgres
sqlserver