SQLite – NULL Values
SQLite NULL is the term used to represent a missing value. A NULL value in a table is a value in a field that appears to be blank. A field with a…
SQLite – UNION Clause
SQLite UNION clause/operator is used to combine the results of two or more SELECT statements without returning any duplicate rows. To use UNION, each SELECT must have the same number of columns…
SQLite – JOINS
SQLite Joins clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using values common to…
SQLite – Constraints
Constraints are the rules enforced on a data columns on table. These are used to limit the type of data that can go into a table. This ensures the accuracy…
SQLite – PRAGMA
SQLite PRAGMA command is a special command to be used to control various environmental variables and state flags within the SQLite environment. A PRAGMA value can be read and it can also…
SQLite – DISTINCT Keyword
SQLite DISTINCT keyword is used in conjunction with SELECT statement to eliminate all the duplicate records and fetching only the unique records. There may be a situation when you have multiple duplicate…
SQLite – HAVING Clause
HAVING clause enables you to specify conditions that filter which group results appear in the final results. The WHERE clause places conditions on the selected columns, whereas the HAVING clause…
SQLite – GROUP BY Clause
SQLite GROUP BY clause is used in collaboration with the SELECT statement to arrange identical data into groups. GROUP BY clause follows the WHERE clause in a SELECT statement and precedes the…
SQLite – ORDER BY Clause
SQLite ORDER BY clause is used to sort the data in an ascending or descending order, based on one or more columns. Syntax Following is the basic syntax of ORDER BY clause.…
SQLite – LIMIT Clause
SQLite LIMIT clause is used to limit the data amount returned by the SELECT statement. Syntax Following is the basic syntax of SELECT statement with LIMIT clause. SELECT column1, column2, columnN FROM…