I am trying to use a window function, but it's not working. The subquery is effectively aggregating.
I would advise avoiding using select-list scalar (and particularly correlated) subqueries when the query level in question also contains a group by. Do the group by in a subquery and then in the parent query pull in whatever subselects you want to execute.
You need to make it easier for people to help. The first post you sent was just a window function. I asked for
detail and you sent a query without one. Given that discrepancy, added to the fact the query is question is not self-contained, I am less than inclined to try and figure out what you are trying to do.
Given me a query that has a window function and looks like, if said window function was removed, it would successfully run, and I'll made an educated guess.
David J.
