OLAP functions are similar to aggregate functions in that they:
Operate on groups of rows (like the GROUP BY clause)
Can filter groups using QUALIFY (like the HAVING clause)
OLAP functions are unlike aggregate functions because they:
Return a data value for each qualifying row - not group.
May not be performed within subqueries.
Showing posts with label Aggregate functions. Show all posts
Showing posts with label Aggregate functions. Show all posts
Monday, April 19, 2010
Subscribe to:
Posts (Atom)