Weather Observation Station 14

Sort by

recency

|

1398 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 DECIMAL(TRUNCATE(MAX(LAT_N), 4), 10, 4) AS LAT_N FROM STATION WHERE LAT_N < 137.2345;

  • + 0 comments

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

  • + 0 comments

    here why are we using truncate why we are not using max only. what exactly does truncate do?

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