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 14
  5. Discussions

Weather Observation Station 14

Sort by

recency

|

1422 Discussions

|

  • srushtijignaben1
     + 0 comments

    select round(max(lat_n), 4) from station where lat_n < 137.2345;

  • iamsohail2001
     + 0 comments

    SELECT ROUND(LAT_N,4) FROM (SELECT LAT_N FROM STATION ORDER BY LAT_N DESC) as LAT_N_MAX WHERE LAT_N < 137.2345 LIMIT 1;

  • yeshwanthreddy08
     + 0 comments

    MS SQL SERVER

    SELECT CAST(ROUND(MAX(LAT_N), 4) AS DECIMAL(10,4)) AS Great_Lat FROM STATION WHERE LAT_N < 137.2345;

  • tanu_janghel
     + 0 comments

    Why is my query not truncating? Getting all the values after the decimal and hence, query is failing.

    SELECT TRUNCATE(MAX(LAT_N)) FROM STATION WHERE LAT_N<137.2345;

  • mohamed_shiban
     + 0 comments
    Select Round(Max(Lat_N),4)
from station
where Lat_N < 137.2345;