Weather Observation Station 17

Sort by

recency

|

1318 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

    MySQL

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

  • + 0 comments

    My SQL

    SELECT ROUND(LONG_W, 4) FROM STATION WHERE LAT_N = ( SELECT MIN(LAT_N) FROM STATION WHERE LAT_N > 38.7780 ); this would do the job

  • + 0 comments

    Alternatively,

    WITH smallest AS ( select lat_n, long_w from station where lat_n > 38.7780 )

    select CAST(Round(long_w,4) as decimal (6,4)) from smallest order by lat_n limit 1;

  • + 0 comments

    MS SQL: select top 1 cast(round(long_w, 4) as decimal(10,4)) from station where lat_n > 38.7780 order by lat_n