You are viewing a single comment's thread. Return to all comments →
WITH CTE AS ( SELECT LONG_W FROM STATION WHERE LAT_N < 137.2345)
SELECT TOP 1 CAST(LONG_W AS NUMERIC (16,4)) FROM CTE WHERE LAT_N < 137.2345 ORDER BY LAT_N DESC;
Weather Observation Station 15
You are viewing a single comment's thread. Return to all comments →
WITH CTE AS ( SELECT LONG_W FROM STATION
WHERE LAT_N < 137.2345)
SELECT TOP 1 CAST(LONG_W AS NUMERIC (16,4)) FROM CTE WHERE LAT_N < 137.2345 ORDER BY LAT_N DESC;