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

Sort by

recency

|

1117 Discussions

|

  • yogeshpachauli46
     + 0 comments

    MS SQL server-

    SELECT CAST( ROUND (MIN(LAT_N),4) AS DECIMAL(10,4)) FROM STATION WHERE LAT_N > 38.7780;

  • mohamed_shiban
     + 0 comments
    SELECT round (lat_n,4)
FROM station
WHERE lat_n > 38.7780
ORDER BY lat_n
limit 1;

  • unstopablegoblin
     + 0 comments

    SELECT ROUND(MIN(LAT_N),4) FROM STATION WHERE LAT_N > 38.7780 GROUP BY LAT_N ORDER BY LAT_N ASC LIMIT 1;

  • julia_nunesng
     + 0 comments

    If you were using SQL Server, try switching to MySQL - it work it for me

  • Ahmed_Wafik
     + 0 comments
    SELECT ROUND(MIN(LAT_N),4) FROM STATION 
WHERE LAT_N > 38.7780 GROUP BY LAT_N ORDER BY LAT_N ASC LIMIT 1;