You are viewing a single comment's thread. Return to all comments →
SELECT TRUNCATE(SUM(lat_n), 4) FROM station WHERE lat_n > 38.7880 AND lat_n < 137.2345;
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 13
You are viewing a single comment's thread. Return to all comments →
For MySQL
There is seperate function called TRUNCATE for cutting off decimal places rather than rounding up.
Although we get the same answer using BETWEEN operator, it is not correct to use it since the start and end values are not included in the range.