Calculates the average value for each group of rows
Counts the number of rows in each group
Filters groups based on a condition
Retrieves the maximum value in each group
ALTER TABLE
UPDATE
MODIFY TABLE
CHANGE TABLE
Retrieves the current date and time
Converts a string to uppercase
Rounds a numeric value to the nearest integer
Returns the length of a string
A virtual table based on the result of a SELECT query
A physical table with stored data
A temporary table for sorting purposes
A table that contains only primary key columns
DENY PRIVILEGES
REVOKE
REMOVE PRIVILEGES
DELETE PRIVILEGES
To sort the result set in ascending order
To filter rows based on a condition
To include subtotals and grand totals in the result set
To perform a join operation between tables
INSERT INTO
ADD RECORD
CREATE RECORD
Returns the greatest value among the specified expressions
Retrieves the last record from a table
Combines two or more strings
Converts a value to uppercase
Modifies the structure of a table
Sets the value of a variable in the current session
Adds a new column to a table
Deletes records from a table
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
Grants the user all privileges on all databases from any host
Grants the user all privileges on a specific database from any host
Grants the user specific privileges on all databases from a specific host
Grants the user permission to create a new database
CONCAT()
COMBINE()
MERGE()
JOIN()
Generates a random number without any seed value
Generates a random number based on a specified seed value
Generates a random string
Retrieves a random record from a table
Concatenates rows into a single string based on a specified condition
Groups rows based on a columns values
Retrieves the minimum value in a column
ADD UNIQUE
UNIQUE COLUMN
SET UNIQUE
CREATE UNIQUE
Returns the current date and time
Returns the username of the current user
Retrieves the maximum value in a column
Displays the structure of a database
Displays a list of all databases in the server
Creates a new database
Shows the relationships between tables
LCASE()
CONVERT()
TOLOWER()