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.
  1. Prepare
  2. SQL
  3. Aggregation
  4. Weather Observation Station 16
  5. Discussions

Weather Observation Station 16

  • swarnavagayen
     + 0 comments
    SELECT CAST(ROUND(MIN(LAT_N),4) AS NUMERIC(6,4))
FROM STATION
WHERE LAT_N > 38.7780;

    OR 

    select cast(round(lat_n,4) as numeric(6,4)) 
from station 
where lat_n>38.7780 
order by lat_n asc limit 1;