advance sqlite

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

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 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 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…

SQL vs SQLite Differences between SQL and SQLite SQL SQLite SQL is a Structured Query Language used to query a Relational Database…

SQLite Detach Database The SQLite DETACH DATABASE statement is used to detach the alias-named database from a database connection which was previously…

SQLite Joins In SQLite, JOIN clause is used to combine records from two or more tables in a database. It unites fields…

SQLite time Function SQLite time function is used to calculate time and return time in ‘HH-MM-SS’ format. Syntax: time(timestring, [ modifier1, modifier2,…