Previous Function
SQL Server 2000
Previous Function
Returns the previous instance from the specified scope.
Syntax
Previous(Expression, AggFunction, PreviousScope, AggScope)
Parameters
- Expression
- (Variant or Binary) The expression on which to perform the aggregation. The expression cannot contain aggregate functions.
- AggFunction
- (Enum) The aggregate value to return. AggFunction must be specified if AggScope is specified, but may be omitted for detail scope.
- PreviousScope
- (String) The name of a grouping that that contains the current scope. For more information about the Scope parameter, see Aggregate Functions.
- AggScope
- (String) The name of a grouping that that contains the current scope. For more information about the Scope parameter, see Aggregate Functions.
Return Type
Returns a Variant or Binary.
