Same

Description

Returns the value that is the same in all the records in the specified attribute.

Syntax

Same ( n )

Arguments

n is a numeric, string, or date expression.

Example

This query returns the same continent value from the IN condition. If cannot find the same value then it returns null.

select Same(continent) as continent from world where country in ( 'Iceland' ,'Croatia','Georgia')

Remarks

Given an attribute, this aggregate function returns a value if all rows in that attribute have the same value or returns null if not all of the rows have the same value. Null values are skipped. If the attribute has all nulls, then null is returned.

See also http://en.wikipedia.org/wiki/Sameness.