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:
© 2014 Microsoft