SQLite Forum

ORDER BY not working for a specific DB/table
Login
same result using 

     ORDER BY cast(lati10 as real), cast(longi as real)

as with 

     ORDER BY lati10+0, longi+0

which was already tried


     380|41.2|9.37497676257462
     380|41.2|16.6342872848924
     792|41.2|43.2255548289229
     860|41.2|66.7126410609169
     408|41.2|129.727571723508
     840|41.2|-73.970001
     840|41.2|-73.964172