Aggregate Functions in SQL

Use

COUNT()

to get the number of results

Count every single result with COUNT (*)

SELECT COUNT (*)
FROM employees

Count every field in a column with a value use COUNT (col_name)

SELECT COUNT (city)
FROM employees

Count every unique field with COUNT (DISTINCT col_name)

SELECT COUNT (DISTINCT city)
FROM employees