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

Sort by

recency

|

1572 Discussions

|

  • pvj_valadares
     + 0 comments
    SELECT
    ROUND(SUM(LAT_N), 4)
FROM
    STATION
WHERE
    LAT_N BETWEEN 38.7880 AND 137.2345

  • SVVBathini
     + 0 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.

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

  • ravikarn0
     + 0 comments

    select round(sum(LAT_N),4)from STATION where LAT_N between 38.7880 and 137.2345;

    This is Simple and Correct Answer.

  • SKSAAKEEB
     + 0 comments

    SELECT TRUNCATE(SUM(LAT_N), 4) FROM STATION WHERE LAT_N > 38.7880 AND LAT_N < 137.2345;

  • debjyoti_ghosh
     + 0 comments
    SELECT 
    FORMAT(ROUND(SUM(LAT_N), 4), '0.####')
FROM 
    STATION
WHERE
        LAT_N > 38.7880
    AND LAT_N < 137.2345;