You are viewing a single comment's thread. Return to all comments →
SELECT ROUND(long_w, 4) FROM Station WHERE lat_n < 137.2345 ORDER BY lat_n DESC LIMIT 1;
SELECT ROUND(long_w, 4) FROM Station WHERE lat_n = (SELECT MAX(lat_n) FROM Station WHERE lat_n <137.2345);
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 15
You are viewing a single comment's thread. Return to all comments →
Using Order By
SELECT ROUND(long_w, 4) FROM Station WHERE lat_n < 137.2345 ORDER BY lat_n DESC LIMIT 1;
Using Subquery
SELECT ROUND(long_w, 4) FROM Station WHERE lat_n = (SELECT MAX(lat_n) FROM Station WHERE lat_n <137.2345);