Weather Observation Station 17

Sort by

recency

|

1308 Discussions

|

  • + 0 comments

    SELECT ROUND(LONG_W,4) FROM STATION WHERE LAT_N > 38.7780 ORDER BY LAT_N ASC LIMIT 1;

  • + 0 comments

    Oracle

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

  • + 0 comments

    select round(long_w,4) from station where lat_n = (select min(lat_n) from station where lat_n > 38.7780);

  • + 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;