p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Language (http://p2p.wrox.com/forumdisplay.php?f=100)
-   -   ADO Data Shape - Filter aggregate (http://p2p.wrox.com/showthread.php?t=67029)

dwperry March 31st, 2008 10:40 AM

ADO Data Shape - Filter aggregate
 
Using the standard syntax of a Hierarchy with Aggregate eg.

Code:

SHAPE  (select * from orders}
   APPEND ({select od.orderid, od.UnitPrice * od.quantity as ExtendedPrice
            from [order details] As od}
          RELATE orderid TO orderid) As rsDetails,
          SUM(ExtendedPrice) AS OrderTotal

Can anyone tell me if there is a way to filter the parent set based on the value of the aggregate field?

ie. WHERE SUM(ExtendedPrice) > 100

Without using the COMPUTE syntax?




All times are GMT -4. The time now is 02:38 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.