Sqlite Tutorial

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…

SQLite Advantages SQLite is a very popular database which has been successfully used with on disk file format for desktop applications like…

SQLite Julianday Function The SQLite julianday function facilitates you to apply modifiers and then returns the date as a Julian Day after…

SQLite Trigger AFTER DELETE It specifies how to create trigger after delete the data. We have two tables COMPANY and AUDIT. COMPANY…

SQLite Aggregate Function SQLite Aggregate functions are the functions where values of multiple rows are grouped together as input on certain criteria…