COUNTSET Function Example | Teradata Vantage - 17.10 - Example: Querying with the COUNTSET Function - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Functions, Expressions, and Predicates

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

The following query takes the input argument 23, which has a data type of BYTEINT and a binary representation of 00010111. Since target_value_arg is not specified, the default value of 1 is used. Therefore, the function counts the number of bit values that are set to 1. The query result is an INTEGER value of 4.