COMPUTE « Analytical Functions « SQL Server / T-SQL Tutorial






14.1.COMPUTE
14.1.1.using the COMPUTE...BY to provide subtotals
14.1.2.Using COMPUTE with aggregate functions.
14.1.3.The use of the COMPUTE clause, with and without the BY portion.
14.1.4.COMPUTE MIN(start_date) BY region
14.1.5.The use of multiple aggregate functions in a COMPUTE clause.