Weather Observation Station 13

Sort by

recency

|

1680 Discussions

|

  • + 0 comments

    MySQL

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

  • + 0 comments

    Why this is not working in MY SQL Server - SELECT ROUND(SUM(LAT_N),4) FROM STATION WHERE LAT_N > 38.7880 AND LAT_N < 137.2345;

  • + 0 comments

    MS SQL Server

    SELECT CAST(SUM(lat_n) AS DECIMAL(10,4)) FROM station WHERE lat_n > 38.7880 AND lat_n <137.2345

  • + 0 comments

    select cast(round(sum(LAT_N),4,1) as decimal(18,4)) from station where LAT_N > 38.7880 and LAT_N < 137.2345 ;

  • + 0 comments

    select truncate(sum(lat_n),4) from station where lat_n between '38.7880' and '137.2345' ;