Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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.

See Also

Other Functions

Show:
© 2015 Microsoft