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

Weather Observation Station 15

Sort by

recency

|

2164 Discussions

|

  • rohan511
     + 0 comments

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

  • ependd19
     + 0 comments

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

    /* pilih long_w dengan 4 angka dibelakang koma dimana nilai maksimal lat_n lebih kecil dari 137.2345 artinya kita mencari nilai yang sejajar antara keduanya */

  • gabesribeiro7
     + 0 comments

    mySQL

    select round(long_w, 4)

    from station

    where lat_n in (select max(lat_n) from station where lat_n < 137.2345)

  • sahil31103
     + 0 comments

    SELECT ROUND(MAX(LONG_W),4) FROM STATION WHERE LAT_N= (SELECT MAX(LAT_N) FROM STATION WHERE LAT_N<137.2345);

  • abhijithsreejit3
     + 0 comments

    MySQL :

    SELECT ROUND(LONG_W,4) AS Western_Longitude FROM STATION WHERE LAT_N=(SELECT MAX(LAT_N) FROM STATION WHERE LAT_N < 137.2345);