Suppose that the set_col SET column contains the
following value:
{3, 7, 9, 16, 0}
The following SELECT statement returns 5 as the number
of elements in the set_col column:
SELECTCARDINALITY(set_col)
FROM table1;
If the collection contains duplicate elements, CARDINALITY counts
each individual element.
Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.