Weather Observation Station 17

Sort by

recency

|

1305 Discussions

|

  • + 1 comment

    SELECT ROUND(LONG_W,4) FROM STATION WHERE LAT_N=(SELECT MIN(LAT_N) FROM STATION WHERE LAT_N>38.7780);

  • + 0 comments

    FOR MYSQL select round(LONG_W,4) from STATION where LAT_N > 38.7780 order by LAT_N ASC LIMIT 1;

  • + 0 comments

    MySQL:

    select round(LONG_W,4) from STATION where LAT_N > 38.7780 order by LAT_N ASC LIMIT 1;

  • + 0 comments

    SELECT CAST(LONG_W AS DECIMAL(10,4)) NewLong_W FROM STATION WHERE LAT_N = (--Step1: Find the smallest LAT_N greater than 38.778 SELECT TOP 1 LAT_N SmallestLat FROM STATION WHERE LAT_N > 38.778 ORDER BY LAT_N)

  • + 0 comments

    SELECT CAST(LONG_W AS DECIMAL(10,4)) NewLong_W FROM STATION WHERE LAT_N = (--Step1: Find the smallest LAT_N greater than 38.778 SELECT TOP 1 LAT_N SmallestLat FROM STATION WHERE LAT_N > 38.778 ORDER BY LAT_N)