Weather Observation Station 14

Sort by

recency

|

1407 Discussions

|

  • + 0 comments

    SELECT TRUNCATE(LAT_N,4) FROM station WHERE LAT_N < 137.2345 ORDER BY LAT_N DESC LIMIT 1;

  • + 0 comments

    select round(max(LAT_N),4) from STATION where LAT_N < 137.2345;

    OR

    select truncate(max(LAT_N),4) from STATION where LAT_N < 137.2345;

  • + 0 comments

    select round(max(LAT_N),4) from STATION where LAT_N < 137.2345;

    OR

    select truncate(max(LAT_N),4) from STATION where LAT_N < 137.2345;

  • + 0 comments

    select cast(Round(max(lat_n),4) as decimal(10,4)) from station where lat_n <137.2345;

  • + 0 comments

    For MySQL Platform

    In MySQL, there is separate funtion for truncating a decimal unlike ROUND function in other platforms. And that function is TRUNCATE

    SELECT TRUNCATE(MAX(lat_n), 4) FROM station
    WHERE lat_n < 137.2345;