SQL Examples
SQL Syntax
SQL SELECT
SQL SELECT DISTINCT
SQL WHERE
SQL AND, OR and NOT Operators
SQL ORDER BY
SQL NULL Values
SQL SELECT TOP
SQL MIN() and MAX()
SQL COUNT, AVG() and SUM()
SQL LIKE
LIKE - select all table rows starting with "a"
LIKE - select all table rows ending with "a"
LIKE - select all table rows that have "or" in any position
LIKE - select all table rows that have "r" in the second position
LIKE - select all table rows that starts with "a" and ends with "o"
LIKE - select all table rows that does NOT start with "a"
SQL Wildcards
Using the % Wildcard
Using the _ Wildcard
Using the [charlist] Wildcard
Using the [!charlist] Wildcard
SQL IN
SQL BETWEEN
SQL Aliases
SQL Joins
SQL UNION
SQL GROUP BY
SQL HAVING
SQL EXISTS
SQL ANY and ALL
SQL CASE
SQL Comments
SQL Database
SQL Database tutorials can be found here:
SQL Create DB
SQL Drop DB
SQL Backup DB
SQL Create Table
SQL Drop Table
SQL Alter Table
SQL Constraints
SQL Not Null
SQL Unique
SQL Primary Key
SQL Foreign Key
SQL Check
SQL Default
SQL Index
SQL Auto Increment
SQL Dates
SQL Views
SQL Injection
SQL Hosting