Weather Observation Station 20

  • + 0 comments

    SQL SERVER

    SELECT DISTINCT ROUND( CAST(PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY LAT_N) OVER() AS DECIMAL(10,4)), 4 ) AS median_lat FROM Station;