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

Weather Observation Station 20

  • sheeraz23445
     + 0 comments

    Two Different & Easy Methods For SQL Server

    1st: Manual Method

    SELECT
    CAST(AVG(LAT_N) AS DECIMAL(10,4))
FROM
(
    SELECT
        LAT_N,
        ROW_NUMBER() OVER (ORDER BY LAT_N) AS RN,
        COUNT(*) OVER () AS N
    FROM
        STATION
) AS X
WHERE
    RN IN (FLOOR((N + 1) / 2.0), CEILING((N + 1) / 2.0));

    2nd: With PERCENTILE_CONT(0.5) Method:

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