Javatpoint Logo
Javatpoint Logo

SQLite COUNT Function

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


Syntax when you use MAX function with GROUP BY clause:


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.


Sqlite Count function 2


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.


Sqlite Count function 3
Next TopicSQLite Sum

Youtube For Videos Join Our Youtube Channel: Join Now

Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA