SQLExamples
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 positionLIKE - select all table rows that have "r" in the second positionLIKE - 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
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 DBSQL Drop DBSQL Backup DBSQL Create TableSQL Drop TableSQL Alter TableSQL ConstraintsSQL Not NullSQL UniqueSQL Primary KeySQL Foreign KeySQL CheckSQL DefaultSQL IndexSQL Auto IncrementSQL DatesSQL ViewsSQL InjectionSQL Hosting
