Browse by Tags

All Tags » Aggregate (RSS)

BUG: Aggregation

Q: I'm getting incorrect results when I run an aggregation query, such as the following: SELECT Orders.OrderDate, SUM(OrderLines.Quantity * OrderLines.QualityReference) AS Total FROM Orders inner join OrderLines on Orders.OrderNo = OrderLines.OrderNo...
Posted by Administrator | with no comments
Filed under: , ,

Nested expressions

Q: Can I perform nested aggregate query expression such as: select [Order ID], [Customer ID] from orders left outer join ( select [Order ID], sum(Quantity * [Unit Price]) as Total from [Order Details] group by [Order ID] ) as details on orders.[Order...
Posted by Administrator | with no comments
More Posts