Weather Observation Station 5

  • + 1 comment
    SELECT  TOP(1)
        CASE 
            WHEN ROW_NUMBER() OVER(ORDER BY LAT_N )=250
                THEN  ROUND(CONVERT(DECIMAL(10, 4), LAT_N), 4) 
        END AS M
      FROM STATION
    ORDER BY  M  DESC