Weather Observation Station 15

Sort by

recency

|

2000 Discussions

|

  • + 0 comments

    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<137.2345 ORDER BY LAT_N DESC LIMIT 1;

    USING WINDOW FUNCTION : SELECT ROUND(LONG_W,4) FROM (SELECT LAT_N, LONG_W, ROW_NUMBER()OVER(ORDER BY LAT_N DESC) FROM STATION WHERE LAT_N< 137.2345)AS sub_query LIMIT 1;

  • + 0 comments

    select round(long_w,4) from station where lat_n<137.2345 order by lat_n desc limit 1

  • + 0 comments

    Derived Table Method

    SELECT CAST(LONG_W AS DECIMAL(10,4)) AS West_Long FROM (SELECT TOP(1) * FROM STATION WHERE LAT_N < 137.2345 ORDER BY LAT_N DESC) AS ABC

  • + 0 comments

    select round(s.LONG_W, 4) from STATION s where s.LAT_N < 137.2345 order by s.LAT_N desc limit 1;