Issue Details (XML | Word | Printable)

Key: CORE-5584
Type: New Feature New Feature
Status: Open Open
Priority: Minor Minor
Assignee: Unassigned
Reporter: Pavel Zotov
Votes: 0
Watchers: 3
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Implement new agg. function for statistic purpoces: MEDIAN() & MEDIAN()OVER()

Created: 17/Jul/17 06:38 PM   Updated: 17/Jul/17 06:38 PM
Component/s: Engine
Affects Version/s: None
Fix Version/s: None

QA Status: No test


 Description  « Hide
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.


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.