Weather Observation Station 13

Sort by

recency

|

1601 Discussions

|

  • + 0 comments
    select Truncate(sum(lat_n),4)
    from station
    where lat_n > 38.7880 
        and lat_n < 137.2345
    
  • + 0 comments

    select cast(t.total_sum as decimal(30,4)) from (SELECT SUM(LAT_N) as total_sum FROM Station WHERE LAT_N > '38.7880' AND LAT_N < '137.2345') t;

  • + 0 comments

    SELECT TO_CHAR(ROUND(SUM(LAT_N), 4), '99990.0000') FROM STATION WHERE LAT_N BETWEEN 38.7880 AND 137.2345;

    THIS WILL BE GIVE YOU THE CORRECT ANSWER

  • + 0 comments

    Easy query:

    SELECT ROUND(SUM(LAT_N), 4) FROM Station WHERE LAT_N > '38.7880' AND LAT_N < '137.2345'

  • + 0 comments

    select round(sum(LAT_N),4) from station where LAT_N>38.7880 and LAT_N<137.2345;

    you can use the truncate or round off ,as per your preference