Aggregates used with group by  Vector and scalar aggregates

Chapter 2: Transact-SQL Functions

Aggregate functions and NULL values

Aggregate functions calculate the summary values of the non-null values in a particular column. If the ansinull option is set off (the default), there is no warning when an aggregate function encounters a null. If ansinull is set on, a query returns the following SQLSTATE warning when an aggregate function encounters a null:

Warning- null value eliminated in set function




Copyright © 2005. Sybase Inc. All rights reserved. Vector and scalar aggregates

View this book as PDF