Aggregate functions  Aggregate functions and NULL values

Chapter 2: Transact-SQL Functions

Aggregates used with group by

Aggregates are often used with group by. With group by, the table is divided into groups. Aggregates produce a single value for each group. Without group by, an aggregate function in the select list produces a single value as a result, whether it is operating on all the rows in a table or on a subset of rows defined by a where clause.





Copyright © 2005. Sybase Inc. All rights reserved. Aggregate functions and NULL values

View this book as PDF