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.

Sign up for GitHub

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

Jump to bottom

Add within group (order by ...) clause support for aggregate functions. #781

Open
igalklebanov opened this issue Nov 24, 2023 · 0 comments · May be fixed by #1024
Open

Add within group (order by ...) clause support for aggregate functions. #781

igalklebanov opened this issue Nov 24, 2023 · 0 comments · May be fixed by #1024
Labels
api Related to library's API enhancement New feature or request mssql Related to MS SQL Server (MSSQL) oracle Related to Oracle postgres Related to PostgreSQL

Comments

@igalklebanov
Copy link
Member

Hey 👋

within group is a clause that allows ordering the aggregated data, usually found in concat-like functions.

This clause is supported in:
@igalklebanov igalklebanov added enhancement New feature or request postgres Related to PostgreSQL api Related to library's API mssql Related to MS SQL Server (MSSQL) oracle Related to Oracle labels Nov 24, 2023
@igalklebanov igalklebanov changed the title Add within group (order by ...) support for aggregate functions. Add within group (order by ...) clause support for aggregate functions. Nov 24, 2023
@ivashog ivashog mentioned this issue Mar 12, 2024
Merged
@ivashog ivashog linked a pull request Jun 5, 2024 that will close this issue
Open
ivashog pushed a commit to ivashog/kysely that referenced this issue Jun 6, 2024
feat(operation-node): add within group to aggregate function node
24d3846 
kysely-org#781
ivashog pushed a commit to ivashog/kysely that referenced this issue Jun 7, 2024
feat(query-builder): add withinGroupOrderBy method to aggregate funct…
c81d766 
…ion builder

kysely-org#781
ivashog pushed a commit to ivashog/kysely that referenced this issue Jun 7, 2024
feat(query-compiler): add within group processing to default query co…
9408cb9 
…mpiler

kysely-org#781
ivashog pushed a commit to ivashog/kysely that referenced this issue Jun 10, 2024
fix(operation-node): fix operation node transformer for withinGroup c…
3bed700 
…lause

kysely-org#781
ivashog pushed a commit to ivashog/kysely that referenced this issue Jun 10, 2024
test(node): add separate order-sensitive aggregate functions test cas…
a28d77c 
…e for withinGroup clause

kysely-org#781
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
api Related to library's API enhancement New feature or request mssql Related to MS SQL Server (MSSQL) oracle Related to Oracle postgres Related to PostgreSQL
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Add within group clause support for aggregate function builder ivashog/kysely
1 participant
@igalklebanov