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.


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 01:36 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.