ACCESS開根號、絕對值

 ACCES裡面可以直接做加減乘除、取絕對值、開根號的運算

select * from( select *,abs(longitude - 120.6487395) as SB01,abs(latitude- 24.1542757) as SB02,sqr(SB01*SB01+SB02*SB02) as SB03 from Member where 條件式 ) order by SB03