数学函数_中值取法

--自算法
SELECT AVG(seq)
  FROM (SELECT MAX(rn) over() AS mx,rn, seq
          FROM (SELECT DENSE_RANK() over(ORDER BY seq) AS rn, seq
                  FROM (SELECT DISTINCT seq FROM stk001 WHERE seq IS NOT NULL) t
                 WHERE ROWNUM <= 11
               )
       )
 WHERE (MOD(mx,2) = 0 AND rn IN(mx/2, mx/2 +1))
    OR (MOD(mx,2) <> 0 AND rn = floor(mx/2)+1)
;
--9i
SELECT
   PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY seq DESC)
      "Median cont", --中值
   PERCENTILE_DISC(0.5) WITHIN GROUP (ORDER BY seq DESC)
      "Median disc"--中值整数???
   FROM stk001
  WHERE seq <= 11
;
--10g
SELECT MEDIAN(seq)
 FROM stk001 t
WHERE ROWNUM <= 10
;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24805255/viewspace-721354/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24805255/viewspace-721354/