SQLite Forum

ORDER BY not working for a specific DB/table
41.200000000000002843 is the closest to 41.2 that can be represented as a floating point number. I imagine that 41.199999999999995735 is the next lower number.

This sort of problem always arises when trying to compare floating point numbers, nothing to do with SQLite.