COUNT()

The COUNT() function is used to find the number of rows of a column. In other words, it counts the total number of records. Note that by default, it does not ignore null values.

For example, if you want to check the number of student names, you can use the following query.

xxxxxxxxxx

SELECT COUNT(StudentName) FROM Class;