We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Aggregation
  4. Weather Observation Station 13
  5. Discussions

Weather Observation Station 13

  • SVVBathini_w
     + 0 comments

    For MySQL Platform

    Using BETWEEN operator will give you the same result. But as per question, its wrong to use that operator because when using BETWEEN, both the start(38.7880) and end(137.2345) are included. If you read the question carefully, its greater than 38.7880(not >=) and less than 137.2345(not <=)

    In MySQL, There is a seperate function for truncating a decimal unlike standard ROUND function in other platforms. And that function is TRUNCATE

    SELECT TRUNCATE(SUM(lat_n), 4) FROM station
WHERE lat_n > 38.7880 AND lat_n < 137.2345;