CS3_Sem2022_Final

Renames a column or table with an alias

• AS
• ANY
• AND
• ALL
• ALTER TABLE

Allows you to specify multiple values in a WHERE clause

• IN
• HAVING
• GROUP BY
• FULL OUTER JOIN
• FROM

Includes rows where either condition is true

• OR
• NOT NULL
• NOT
• LIMIT
• LIKE

Adds a column in an existing table

• ADD
• WHERE
• VIEW
• VALUES
• UPDATE

Returns true if all of the subquery values meet the condition

• ALL
• ALTER TABLE
• ALTER COLUMN
• ALTER
• ADD CONSTRAINT

Only includes rows where both conditions is true

• AND
• ALL
• ALTER TABLE
• ALTER COLUMN
• ALTER

Returns true if any of the subquery values meet the condition

• ANY
• AND
• ALL
• ALTER TABLE
• ALTER COLUMN

Sorts the result set in ascending order

• ASC
• AS
• ANY
• AND
• ALL

Only includes rows where a condition is not true

• NOT
• LIMIT
• LIKE
• LEFT JOIN
• JOIN

Specifies which columns and values that should be updated in a table

• SET
• SELECT TOP
• SELECT INTO
• SELECT DISTINCT
• SELECT