-
SQLite Tutorial
- sqlite-tutorial
- sql-vs-sqlite
- sqlite-history
- sqlite-features
- sqlite-advantages
- sqlite-installation
- sqlite-commands
- sqlite-syntax
- sqlite-data-types
- sqlite-operators
- sqlite-expressions
Databases
Table
CRUD Operation
Clauses/Conditions
- sqlite-where
- sqlite-and
- sqlite-or
- sqlite-like
- sqlite-glob
- sqlite-limit
- sqlite-order-by
- sqlite-group-by
- sqlite-having
- sqlite-distinct
- sqlite-union
- sqlite-union-all
SQLite Joins
SQLite Date & Time
- sqlite-date-and-time
- sqlite-date()
- sqlite-datetime()
- sqlite-juliandday()
- sqlite-now()
- sqlite-strftime()
- sqlite-time()
Aggregate Functions
SQLite Triggers
SQLite Keys
SQLite Import/Export
Connectivity
Interview Questions
SQLite COUNT FunctionSQLite COUNT Function is used to fetch the total count of an expression. Syntax: Syntax when you use MAX function with GROUP BY clause: Example1: We have a table named "STUDENT", having the following data:  Count all the number of students in the "STUDENT" table where AGE is greater than 22. Output:  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. Output: 
Next TopicSQLite Sum
|