Browse by Tags

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 GROUP BY Orders.OrderDate A: The product team have...

Posted to SQL Server CE FAQ (Weblog) by Administrator on 02-10-2007
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 ID]=details.[Order ID] A: No, unfortunately as per...

Posted to SQL Server CE FAQ (Weblog) by Administrator on 02-09-2007

Page 1 of 1 (2 items)

SQL Server CE Portal