Create offline cube files (.cub) with OlapCube. Download Now!


table of contents

Tail

Returns a subset from the end of a set.

Syntax

Tail(«Set»[, «Count»])

Remarks

This function returns the last «Count» elements in a set. The order of elements is preserved. The default value of «Count» is 1. If «Count» is less than 1, the empty set is returned. If «Count» exceeds the number of tuples in the set, the original set is returned.

Example

The following code returns the set {France, Germany, Japan}:

Tail({USA, Canada, France, Germany, Japan}, 3)