advance sqlite

SQLite SUM Function The SQLite SUM function is used to return the summed value of an expression. Syntax: SELECT SUM(aggregate_expression) FROM tables…

SQLite DISTINCT Clause The SQLite DISTINCT clause is used with SELECT statement to eliminate all the duplicate records and fetching only unique…

SQLite UPDATE Query In SQLite, UPDATE query is used to modify the existing records in a table. It is used with WHERE…

SQLite WHERE Clause The SQLite WHERE clause is generally used with SELECT, UPDATE and DELETE statement to specify a condition while you…

SQLite Union All Operator The SQLite UNION ALL operator is used to combine the result of two or more SELECT statement without…

SQLite Union Operator SQLite UNION Operator is used to combine the result set of two or more tables using SELECT statement. The…

SQLite Create Database In SQLite, the sqlite3 command is used to create a new database. Syntax: sqlite3 DatabaseName.db Your database name should…

SQLite GLOB Clause (Operator) The SQLite GLOB operator matches only text values against a pattern by using wildcards. When the search expression…

SQLite OR Operator The SQLite OR Operator is generally used with SELECT, UPDATE and DELETE statement to combine multiple conditions. OR operator…

SQLite Create Table In SQLite, CREATE TABLE statement is used to create a new table. While creating the table, we name that…