MIN()
LEAST()
SMALL()
LOWER()
Returns the next value in a result set based on a specified order
Counts the number of rows in a result set
Retrieves the previous value in a result set based on a specified order
Performs a left outer join between tables
DROP TABLE
DELETE TABLE
REMOVE TABLE
ERASE TABLE
Automatically updates the foreign key value in the child table if the referenced key is updated
Automatically deletes the foreign key value in the child table if the referenced key is deleted
Automatically inserts a new foreign key value in the child table if the referenced key is inserted
Automatically modifies the foreign key value in the child table if the referenced key is modified
CREATE VIEW
MAKE VIEW
VIEW TABLE
DEFINE VIEW
To retrieve all rows from both tables, even if there is no match
To retrieve only the common rows between two tables based on a related column
To retrieve rows from the first table only
To retrieve rows from the second table only
DROP CONSTRAINT
REMOVE CONSTRAINT
ALTER TABLE
DELETE CONSTRAINT
To calculate the sum of values in a column
To calculate the average value of numeric column values
To count the number of records in a table
To find the maximum value in a column
CREATE INDEX
MAKE INDEX
INDEX TABLE
DEFINE INDEX
To retrieve data from a table
To describe the structure of a database
To create a new table
To show the structure of a table
To filter rows based on a condition
To perform conditional logic within a query
To join tables based on a condition
LIKE
MATCH
CONTAINS
COMPARE
Commits the changes made in the transaction
Undoes the changes made in the transaction and restores the data to its original state
Saves the changes temporarily
Clears the transaction log
AND
OR
NOT
XOR
To display the structure of a table
To display a list of all tables in the current database
To show the relationships between tables
To retrieve rows from the first table and matching rows from the second table
To retrieve rows from the second table and matching rows from the first table
NOW()
CURRENT_DATE()
GETDATE()
SYSDATE()
To automatically execute a set of SQL statements when a specific event occurs
To create a temporary table
To delete records from a table
To modify the structure of a table
Reducing the redundancy and dependency of data in a database
Adding redundancy to improve data integrity
Increasing the dependency of data between tables
Modifying the structure of a table
GRANT ALL PRIVILEGES
GRANT SELECT
GRANT PERMISSION
GRANT ROLE