Weather Observation Station 17

Sort by

recency

|

1341 Discussions

|

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

    For MYSql: 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 > 38.7780 order by LAT_N asc limit 1;

  • + 0 comments

    Nothing much but there is a typo in the problem statement: "(LONG_W)where".

  • + 0 comments

    SELECT TOP 1 CAST(LONG_W as decimal(10,4)) FROM STATION WHERE LAT_N = (SELECT MIN (LAT_N) FROM STATION WHERE LAT_N > 38.7788)