61. COUNT All Records

COUNT Function

COUNT returns the number of rows.

Count All Rows

1SELECT COUNT(*) FROM students;

Result

With WHERE

1SELECT COUNT(*) FROM students
2WHERE course = 'Python';

Returns: Number of Python students.