SQL Data Manipulation Commands

EXISTS

Checks whether a subquery returns any rows

BETWEEN

Checks whether an attribute value is within a range

LIKE

Checks whether an attribute value matches a given string pattern

IN

Checks whether an attribute value matches any value within a value list

DELETE

Deletes one or more rows from a table

DISTINCT

Limites values to unique values

UPDATE

Modifies an attributes alues in one or more tables rows

GROUP BY

Orders the selected rows based on one or more attributes

ORDER BY

Orders the selected rows based on one or more attributes

COMMIT

Permanently saves data changes

ROLLBACK

Restores data to their originial values

MAX

Returns th emaximum attribute value found in a given column

AVG

Returns the average of all values for a given column

MIN

Returns the minnimum attribute value found in a given column

SUM

Returns the sum of all values for a given column

COUNT

Returns the the number of rows with non-null values for a given column

=, <,>,<=,>=, <>

Used in conditional expressions

IS NULL

checks whether an attribute value is null

INSERT

inserts rows into a table

WHERE

restricts the eslection of rows based on a conditional expression

HAVING

restricts the selection of grouped rows based on a condition

SELECT

selects attributes from rows in one or more tables or views

AND/OR/NOT

used in conditional expressions