in

SQL Server CE Portal

This site is dedicated to all versions of SQL Server Compact Edition (CE)

Browse by Tags

  • 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 (1 items)
Powered by Community Server (Commercial Edition), by Telligent Systems