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
|
1318 Discussions
|
Please Login in order to post a comment
select round(long_w,4) from station where lat_n=(select min(lat_n) from station where lat_n>38.7780)
MySQL
SELECT ROUND(LONG_W, 4) FROM STATION WHERE LAT_N > 38.7780 ORDER BY LAT_N LIMIT 1;
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
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;
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