Knowledge Base & Tutorials
In-depth technical guides combined with interactive browser sandboxes.
Financial Automation
Databases
SQL Home
SQL is a standard language for storing, manipulating and retrieving data in databases.
SQL Introduction
SQL stands for Structured Query Language.
SQL Syntax
Database tables contain rows of data. The most important SQL commands start with keywords like SELECT, UPDATE, DELETE, etc.
SQL Select
The SELECT statement is used to select data from a database.
SQL Select Distinct
The SELECT DISTINCT statement is used to return only distinct (different) values.
SQL Where
The WHERE clause is used to filter records.
SQL Order By
The ORDER BY keyword is used to sort the result-set in ascending or descending order.
SQL And
The AND operator displays a record if all the conditions separated by AND are TRUE.
SQL Or
The OR operator displays a record if any of the conditions separated by OR is TRUE.
SQL Not
The NOT operator displays a record if the condition(s) is NOT TRUE.
SQL Insert Into
The INSERT INTO statement is used to insert new records in a table.
SQL Null Values
A field with a NULL value is a field with no value.
SQL Update
The UPDATE statement is used to modify the existing records in a table.
SQL Delete
The DELETE statement is used to delete existing records in a table.
SQL Select Top
The SELECT TOP clause is used to specify the number of records to return.
SQL Aggregate Functions
Aggregate functions calculate a single value from a set of values.
SQL Min()
The MIN() function returns the smallest value of the selected column.