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
|
1045 Discussions
|
Please Login in order to post a comment
SELECT ROUND(MIN(LONG_W), 4) AS WESTERN_LONGITUDE FROM STATION WHERE LAT_N >= 38.7780;
MS SQL SERVER: SELECT CAST(LONG_W AS DECIMAL(10,4)) FROM STATION WHERE LAT_N IN (SELECT MIN(LAT_N) FROM STATION WHERE LAT_N>38.7780 );
SELECT cast(long_w as decimal(16,4)) FROM STATION WHERE LAT_N = (SELECT MIN(LAT_N) FROM STATION WHERE LAT_N > 38.7780) order by lat_n desc limit 1;
SELECT ROUND(long_w,4) FROM station WHERE lat_n >= 38.7780 ORDER BY lat_n LIMIT 1
for SQL Server:
select top 1 cast(long_w as numeric(20,4)) from station where lat_n>38.7780 order by lat_n asc;