Previous Query
Next Query
Distance between two chosen atoms over a simulation
SELECT
SQRT(((POWER(c1.x_coord - c.x_coord , 2)) + (POWER(c1.y_coord - c.y_coord , 2)) + (POWER(c1.z_coord - c.z_coord , 2))))
from dbo.[coord_678] AS c
join dbo.[coord_678] AS c1
on (c.step = c1.step)
WHERE c.atom_number = 1
and c1.atom_number = 10
order by c1.step;