euclidean-distance-calculation-sql

gistfile1.txt

SELECT 
  id,
  sqrt(
    power(f1 - (-0.09077361), 2) +
    power(f2 - (0.10373443), 2) +
    power(f3 - (0.00798536), 2) +
    power(f4 - (-0.06935258), 2) +
    power(f5 - (0.01923059), 2) +
    power(f6 - (-0.01380458), 2) +
    power(f7 - (-0.08229813), 2) +
    power(f8 - (-0.09294511), 2) +
    power(f9 - (0.18890141), 2) +
    power(f10 - (-0.10929787), 2) +
    power(f11 - (0.24626128), 2) +
    power(f12 - (0.08557525), 2) +
    power(f13 - (-0.21460623), 2) +
    power(f14 - (-0.14558198), 2) +
    power(f15 - (0.05293326), 2) +
    power(f16 - (0.11696213), 2) +
    power(f17 - (-0.18161479), 2) +
    power(f18 - (-0.0758142), 2) +
    power(f19 - (-0.10596617), 2) +
    power(f20 - (-0.12528923), 2) +
    power(f21 - (0.02021212), 2) +
    power(f22 - (-0.00375831), 2) +
    power(f23 - (0.10543737), 2) +
    power(f24 - (0.03472294), 2) +
    power(f25 - (-0.12894149), 2) +
    power(f26 - (-0.34515691), 2) +
    power(f27 - (-0.06032623), 2) +
    power(f28 - (-0.19111864), 2) +
    power(f29 - (-0.00674001), 2) +
    power(f30 - (-0.0981002), 2) +
    power(f31 - (-0.07665598), 2) +
    power(f32 - (0.00575087), 2) +
    power(f33 - (-0.17232881), 2) +
    power(f34 - (-0.11649894), 2) +
    power(f35 - (0.02338134), 2) +
    power(f36 - (-0.01495686), 2) +
    power(f37 - (0.01169539), 2) +
    power(f38 - (0.01110091), 2) +
    power(f39 - (0.21533921), 2) +
    power(f40 - (0.03269488), 2) +
    power(f41 - (-0.10649491), 2) +
    power(f42 - (0.08278903), 2) +
    power(f43 - (0.01747225), 2) +
    power(f44 - (0.22928298), 2) +
    power(f45 - (0.28257564), 2) +
    power(f46 - (0.07885517), 2) +
    power(f47 - (-0.00148859), 2) +
    power(f48 - (-0.09197415), 2) +
    power(f49 - (0.11621907), 2) +
    power(f50 - (-0.23295426), 2) +
    power(f51 - (0.07588145), 2) +
    power(f52 - (0.143179), 2) +
    power(f53 - (0.07528645), 2) +
    power(f54 - (0.02851133), 2) +
    power(f55 - (0.10191229), 2) +
    power(f56 - (-0.17811552), 2) +
    power(f57 - (0.00373968), 2) +
    power(f58 - (0.08938754), 2) +
    power(f59 - (-0.15409832), 2) +
    power(f60 - (0.0182692), 2) +
    power(f61 - (0.02022113), 2) +
    power(f62 - (-0.0637815), 2) +
    power(f63 - (-0.05582062), 2) +
    power(f64 - (0.04433793), 2) +
    power(f65 - (0.22493632), 2) +
    power(f66 - (0.11040443), 2) +
    power(f67 - (-0.13137142), 2) +
    power(f68 - (-0.04087815), 2) +
    power(f69 - (0.14366727), 2) +
    power(f70 - (-0.02882116), 2) +
    power(f71 - (0.0186263), 2) +
    power(f72 - (0.01370643), 2) +
    power(f73 - (-0.19327201), 2) +
    power(f74 - (-0.19941731), 2) +
    power(f75 - (-0.23193142), 2) +
    power(f76 - (0.08670173), 2) +
    power(f77 - (0.3685815), 2) +
    power(f78 - (0.18389685), 2) +
    power(f79 - (-0.19350384), 2) +
    power(f80 - (0.02005921), 2) +
    power(f81 - (-0.20256267), 2) +
    power(f82 - (0.02735742), 2) +
    power(f83 - (0.0761398), 2) +
    power(f84 - (0.00612574), 2) +
    power(f85 - (-0.07387595), 2) +
    power(f86 - (-0.13169651), 2) +
    power(f87 - (-0.0221698), 2) +
    power(f88 - (0.05673034), 2) +
    power(f89 - (0.07980409), 2) +
    power(f90 - (0.04200701), 2) +
    power(f91 - (-0.05105552), 2) +
    power(f92 - (0.21742506), 2) +
    power(f93 - (-0.02585672), 2) +
    power(f94 - (0.06073647), 2) +
    power(f95 - (0.01770991), 2) +
    power(f96 - (0.05006114), 2) +
    power(f97 - (-0.14359206), 2) +
    power(f98 - (-0.03330628), 2) +
    power(f99 - (-0.17855991), 2) +
    power(f100 - (-0.06400941), 2) +
    power(f101 - (0.03093304), 2) +
    power(f102 - (-0.03427393), 2) +
    power(f103 - (0.04758294), 2) +
    power(f104 - (0.14619979), 2) +
    power(f105 - (-0.23467502), 2) +
    power(f106 - (0.05409027), 2) +
    power(f107 - (0.0042281), 2) +
    power(f108 - (-0.03830988), 2) +
    power(f109 - (0.03858205), 2) +
    power(f110 - (0.07355759), 2) +
    power(f111 - (-0.03055457), 2) +
    power(f112 - (-0.04597627), 2) +
    power(f113 - (0.06290605), 2) +
    power(f114 - (-0.23721318), 2) +
    power(f115 - (0.24152282), 2) +
    power(f116 - (0.23938343), 2) +
    power(f117 - (0.03457258), 2) +
    power(f118 - (0.16853549), 2) +
    power(f119 - (0.06903636), 2) +
    power(f120 - (0.0163824), 2) +
    power(f121 - (-0.00856825), 2) +
    power(f122 - (-0.02275476), 2) +
    power(f123 - (-0.18283436), 2) +
    power(f124 - (-0.05265021), 2) +
    power(f125 - (0.04878465), 2) +
    power(f126 - (0.07803915), 2) +
    power(f127 - (0.0778369), 2) +
    power(f128 - (0.00951046), 2)
  ) as distance
FROM 
  face_feature
ORDER BY 
  distance
LIMIT
  1
;