Weather Observation Station 14

Sort by

recency

|

1385 Discussions

|

  • + 0 comments

    MS SQL Server

    SELECT CAST(MAX(lat_n) AS DECIMAL (10,4)) FROM station WHERE lat_n<137.2345

  • + 0 comments

    select truncate(max(lat_n),4) from station where lat_n < '137.2345' ;

  • + 0 comments
    SELECT CAST(ROUND(MAX(LAT_N), 4) AS NUMERIC(7, 4))
    FROM STATION 
    WHERE LAT_N < 137.2345;
    

    You can use TRUNCATE also instead of ROUND

  • + 0 comments

    My answer:

    SELECT TRUNCATE(MAX(LAT_N), 4)
    FROM STATION
    WHERE LAT_N < 137.2345;
    
  • + 0 comments

    SELECT TRUNCATE(MAX(LAT_N),4) FROM STATION WHERE LAT_N<137.2345;