Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #54.9K
I am joining a select statement and a subquery with a left outer join. The subquery does a an average on one of the selects columns grouped by name, and I only select this sum value in the resultant joined result set. Typically there will the select result set will … |
|
I have a very large with milions of rows: I will attempts to create a reduced SSCCE to explain my problem. The below applies for multiple locations, and I will attempt to describe my problem assuming one location. The metric are also foreign keys so to get the real value … |