[FB-Tracker] Created: (CORE-5584) Implement new agg. function for statistic purpoces: MEDIAN() & MEDIAN()OVER()

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[FB-Tracker] Created: (CORE-5584) Implement new agg. function for statistic purpoces: MEDIAN() & MEDIAN()OVER()

JIRA tracker@firebirdsql.org
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
Loading...