Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add support for SQL Standard PERCENTILE_CONT() and PERCENTILE_DISC() inverse distribution functions #2498

Closed
lukaseder opened this issue May 31, 2013 · 0 comments

Comments

@lukaseder
Copy link
Member

Documentation:

Interesting to note that SQL Server adopted Oracle's WITHIN GROUP (ORDER BY ...) clause, which we might see again for ordered aggregate functions.

These are also available in PostgreSQL 9.4 (see #3871) and are a prerequisite for #3872


Note: Interestingly, SQL Server seems to support these only as window functions, whereas other DBs support them only as aggregate functions!

@lukaseder lukaseder changed the title Add support for SQL Server 2012 PERCENTILE_CONT() and PERCENTILE_DISC() analytic functions Add support for SQL Standard PERCENTILE_CONT() and PERCENTILE_DISC() analytic functions Dec 19, 2014
@lukaseder lukaseder changed the title Add support for SQL Standard PERCENTILE_CONT() and PERCENTILE_DISC() analytic functions Add support for SQL Standard PERCENTILE_CONT() and PERCENTILE_DISC() inverse distribution functions Dec 19, 2014
lukaseder added a commit that referenced this issue Dec 19, 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant