select * from Table where data=2.6
After running the above query, db returned an empty result set. But Seen from table, there are many rows matching data=2.6 criterion.
Here the type of 'data' column is FLOAT. If changing the value to an integer like 'where data=2', the matched result sets will be returned.
Please let me know if anyone see the error on the query? Many thanks!