-
SQLite Tutorial
- sqlite-tutorial
- sql-vs-sqlite
- sqlite-history
- sqlite-features
- sqlite-advantages
- sqlite-installation
- sqlite-commands
- sqlite-syntax
- sqlite-data-types
- sqlite-operators
- sqlite-expressions
Databases
Table
CRUD Operation
Clauses/Conditions
- sqlite-where
- sqlite-and
- sqlite-or
- sqlite-like
- sqlite-glob
- sqlite-limit
- sqlite-order-by
- sqlite-group-by
- sqlite-having
- sqlite-distinct
- sqlite-union
- sqlite-union-all
SQLite Joins
SQLite Date & Time
- sqlite-date-and-time
- sqlite-date()
- sqlite-datetime()
- sqlite-juliandday()
- sqlite-now()
- sqlite-strftime()
- sqlite-time()
Aggregate Functions
SQLite Triggers
SQLite Keys
SQLite Import/Export
Connectivity
Interview Questions
SQLite Outer JoinIn SQL standard, there are three types of outer joins:
But, SQLite supports only Left Outer Join. SQlite Left Outer JoinThe SQLite left outer join is used to fetch all rows from the left hand table specified in the ON condition and only those rows from the right table where the join condition is satisfied. Syntax: Or Image representation:  We have two tables "STUDENT" and "DEPARTMENT".  The "STUDENT" table is having the following data:  The "DEPARTMENT" table is having the following data:  Let's take the above two tables "STUDENT" and "DEPARTMENT" and make an inner join according to the below conditions: Example: 
Next TopicSQLite Cross Join
|