Please enable JavaScript.
Coggle requires JavaScript to display documents.
SQL, Data Definition Language, Data Manipulation Language, Data Control…
SQL
AGGREGATION
AVG()
SUM()
COUNT()
MIN()
MAX()
DML
SELECT
DISTINCT
*
INSERT
UPDATE
DELETE
JOIN
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
DDL
CREATE
TABLE
VIEW
ALTER
TABLE
ADD
COLUMN
CONSTRAINTS
UNIQUE
NOT NULL
PRIMARY KEY
FOREIGN KEY
CHECK
DEFAULT
REMOVE
COLUMN
CONSTRAINT
MODIFY
DATA TYPE
DATA TYPE LENGTH
DCL
GRANT
REVOKE
GROUP BY
GROUP BY COLUMN
HAVING
ORDER BY
ORDER BY ASC
ORDER BY DESC
WHERE
operator
<>, =, <, <=, >, >=
AND, OR
ALL
ANY
BETWEEN
IN
LIKE
EXISTS
NOT
ALIAS
AS
Data Definition Language
Data Manipulation Language
Data Control Language
BY GASPER