|< < 25 > >|

Aggregation

Counting values

count can also be used to count the occurrences of values in a single column. (Only a single column.)

Data

select count(x) from t	6
select count(y) from t	5

• Duplicates are counted.
• NULLs are not counted.

|< < 25 > >|