Export (0) Print
Expand All

Subset

SQL Server 2000

Subset

Returns a subset of tuples from a specified set.

Syntax

Subset(«Set», «Start»[, «Count»])

Remarks

This function returns «Count» tuples from «Set» as a set, starting at position «Start». «Start» is zero-based: 0 corresponds to the first tuple in the set, 1 corresponds to the second, and so on. If «Count» is not specified, all tuples from «Start» to the end of the set are returned.

Example

The following example returns the set {USA, Canada}:

Subset({USA, Canada, France, Germany, Japan, Iceland, Peru}, 0, 2)
Show:
© 2014 Microsoft