COUNT() Function

SQL COUNT() Function

Submitted by admin on

COUNT is a simple aggregate function provided by SQL. As it is clear from its name that it simply counts the number of records in the table and returns the total count.

There are three (3) different usage for the Count function.

  • SQL COUNT(column_name)
  • COUNT(*)
  • COUNT(DISTINCT column_name)

Consider the following table for this exercise

Employess

Subscribe to COUNT() Function