glob

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…

SQLite GROUP BY Clause The SQLite GROUP BY clause is used with SELECT statement to collaborate the same identical elements into groups.…

SQLite ORDER BY Clause The SQLite ORDER BY clause is used to sort the fetched data in ascending or descending order, based…

SQLite Cross Join The SQLite Cross join is used to match every rows of the first table with every rows of the…

SQLite HAVING Clause The SQLite HAVING clause is used to specify conditions that filter which group results appear in the final results.…

SQLite Outer Join In SQL standard, there are three types of outer joins: Left outer join Right outer join Full outer join.…

SQLite Data Types SQLite data types are used to specify type of data of any object. Each column, variable and expression has…

SQLite History SQLite was designed originally on August 2000. It is named SQLite because it is very light weight (less than 500Kb…

SQLite Primary Keys SQLite primary key is a simple field or a combination of fields which is used to uniquely define a…