COUNT(expr) [over_clause]

JUMLAH(expr) [klausul_lebih]

Syntax

MYSQL Copy

SELECT student.student_name,COUNT(*)
       FROM student,course
       WHERE student.student_id=course.student_id
       GROUP BY student_name;

Contoh

Example

Returns a count of the number of non-NULL values of expr in the rows retrieved by a SELECT statement. The result is a BIGINT value.

MYSQL Copy

SELECT student.student_name,COUNT(*)
       FROM student,course
       WHERE student.student_id=course.student_id
       GROUP BY student_name;

Example 2

If there are no matching rows, COUNT() returns 0. COUNT(NULL) returns 0.

MYSQL Copy

SELECT COUNT(*) FROM student;