Implement new agg. function for statistic purpoces: MEDIAN() & MEDIAN()OVER()
-----------------------------------------------------------------------------
Key: CORE-5584
URL: http://tracker.firebirdsql.org/browse/CORE-5584
Project: Firebird Core
Issue Type: New Feature
Components: Engine
Reporter: Pavel Zotov
Priority: Minor
Please consider to implement aggregate function MEDIAN() which can be very
useful when we want to evaluate 'most typical' value from set which does
contain several values with big deviation: { 12, 13, 11, 14, 11, 11, 11, 12,
9999, 1, 12,13, 13 } ==> median = 12 (compare with average = 779.46).
Explanation: https://en.wikipedia.org/wiki/Median
Online eval.: http://www.alcula.com/calculators/statistics/median/
PS. Oracle has this function since 10g.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
