We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Weather Observation Station 17
Weather Observation Station 17
Sort by
recency
|
1341 Discussions
|
Please Login in order to post a comment
For MYSql:
SELECT ROUND(LONG_W,4) FROM STATION WHERE LAT_N > 38.7780 ORDER BY LAT_N ASC LIMIT 1;
For MYSql: SELECT ROUND(LONG_W,4) FROM STATION WHERE LAT_N > 38.7780 ORDER BY LAT_N ASC LIMIT 1;
select round(LONG_W, 4) from STATION where LAT_N > 38.7780 order by LAT_N asc limit 1;
Nothing much but there is a typo in the problem statement: "(LONG_W)where".
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)