Support SQL window functions
Both [SQL Server](https://docs.microsoft.com/en-us/sql/t-sql/queries/select-over-clause-transact-sql?view=sql-server-2017) and [PostgreSQL](https://www.postgresql.org/docs/current/static/tutorial-window.html) seem to support window functions in a similar way - in at least some cases the syntax even seems to be identical. It could be nice to add support for this to EF Core. A main question is how this would be expressed in LINQ, ~AFAIK there's no way to do these kinds of operations in memory.~ **NOTE: For an up-to-date design proposal for expressing window functions with LINQ, see https://github.com/dotnet/efcore/issues/12747#issuecomment-3152575891.**
Posted by roji on Jul 21, 2018, 8:07 AM
Tags
Related issues
Raise real-world problems, find people facing the same issue, and discuss solutions.4,000 issues0 comments
support (Sysadmin)
Support connecting to remote devcontainers (devcontainer on remote host)
Option to use Waffle menu or links displayed normally
I also attempted to package ROCM on musl.
But why is there no such pushback agains linux kernel?
OpenCode Support
Upcoming changes to the tado° API
Allow Mac users to use Apple native containerization
Support for the Containerization Framework on macOS
Support SQL window functions
Both [SQL Server](https://docs.microsoft.com/en-us/sql/t-sql/queries/select-over-clause-transact-sql?view=sql-server-2017) and [PostgreSQL](https://www.postgresql.org/docs/current/static/tutorial-window.html) seem to support window functions in a similar way - in at least some cases the syntax even seems to be identical. It could be nice to add support for this to EF Core. A main question is how this would be expressed in LINQ, ~AFAIK there's no way to do these kinds of operations in memory.~ **NOTE: For an up-to-date design proposal for expressing window functions with LINQ, see https://github.com/dotnet/efcore/issues/12747#issuecomment-3152575891.**
Comments (0)
No comments yet. Start the discussion.