Weather Observation Station 17

Sort by

recency

|

1286 Discussions

|

  • + 0 comments

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

  • + 0 comments

    Using SQL Server

    SELECT TOP 1 FORMAT(ROUND(LONG_W,4),"###.####") FROM STATION WHERE LAT_N > 38.7780 ORDER BY LAT_N

  • + 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 = (select min(LAT_N) from station where LAT_N>38.7780);