Select Statement
SELECT _column1_, _column2, ..._
FROM _table_name_;
SELECT DISTINCT _column1_, _column2, ..._
FROM _table_name_;
SELECT _column1_, _column2, ..._
FROM _table_name_
WHERE _condition_;
SELECT TOP _number_|_percent_ _column_name(s)_
FROM _table_name
WHERE _condition_;
Insert Statement
INSERT INTO _table_name_ (_column1_, _column2_, _column3_, ...)
VALUES (_value1_, _value2_, _value3_, ...);
INSERT INTO _table_name_
VALUES (_value1_, _value2_, _value3_, ...);
Delete Statement
DELETE FROM _table_name_ WHERE _condition_;
Update Statement
UPDATE _table_name_
SET _column1_ = _value1_, _column2_ = _value2_, ...
WHERE _condition_;
Conditionals
AND Syntax
SELECT _column1_, _column2, ..._
FROM _table_name_
WHERE _condition1_ AND _condition2_ AND _condition3 ..._;
OR Syntax
SELECT _column1_, _column2, ..._
FROM _table_name_
WHERE _condition1_ OR _condition2_ OR _condition3 ..._;
ORDER BY Syntax
SELECT _column1_, _column2, ..._
FROM _table_name_
ORDER BY _column1, column2, ..._ ASC|DESC;
NOT Syntax
SELECT _column1_, _column2, ..._
FROM _table_name_
WHERE NOT _condition_;
IS NULL Syntax
SELECT _column_names
_FROM _table_name_
WHERE _column_name_ IS NULL;
IS NOT NULL Syntax
SELECT _column_names
_FROM _table_name_
WHERE _column_name_ IS NOT NULL;
LIKE Syntax
SELECT _column1, column2, ..._
FROM _table_name_
WHERE _columnN_ LIKE '%example';