Weather Observation Station 15

Sort by

recency

|

2176 Discussions

|

  • + 0 comments

    MySQL

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

  • + 0 comments

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

  • + 0 comments

    For MS SQL Server

    SELECT CONVERT(DECIMAL(18, 4), LONG_W) FROM STATION WHERE LAT_N = (SELECT MAX(LAT_N) FROM STATION WHERE LAT_N < 137.2345);
    
  • + 0 comments

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

  • + 0 comments
    SELECT CAST(ROUND(LONG_W,4) AS NUMERIC(7, 4))
    FROM STATION
    WHERE LAT_N < 137.2345
    ORDER BY LAT_N DESC
    LIMIT 1;