Weather Observation Station 17

Sort by

recency

|

1325 Discussions

|

  • + 0 comments
    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>38.7780 order by LAT_N ASC limit 1;

  • + 0 comments

    **> 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>38.7780 ORDER BY LAT_N ASC LIMIT 1;

  • + 0 comments

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