SQLite COUNT Function

by Online Tutorials Library July 14, 2022

SQLite COUNT Function

SQLite COUNT Function is used to fetch the total count of an expression.

Syntax:

Syntax when you use MAX function with GROUP BY clause:

  SELECT expression1, expression2, … expression_n  COUNT(aggregate_expression)  FROM tables  [WHERE conditions]  GROUP BY expression1, expression2, … expression_n;   

Example1:

We have a table named “STUDENT”, having the following data:

Sqlite Count function 1

Count all the number of students in the “STUDENT” table where AGE is greater than 22.

Output:

Sqlite Count function 2

Example2:

Using GROUP BY clause with COUNT function:

Count the number of students with a specific name where the age is greater than 22 and group by the students by name.

  SELECT NAME, COUNT(*) AS “Number Of Students”  FROM STUDENT  WHERE AGE > 22  GROUP BY NAME;  

Output:

Sqlite Count function 3

Next TopicSQLite Sum

SQLite COUNT Function

SQLite COUNT Function

SUM Function in SQL

Event Listener

You may also like