SELECT: The SELECT statement is used to retrieve data from one or more tables. It specifies the columns to be retrieved and can also include filtering and sorting criteria.
JOIN: The JOIN statement is used to combine data from two or more tables based on a common column.
WHERE: The WHERE statement is used to filter data based on a condition. It specifies the criteria that must be met for a row to be included in the result set.
GROUP BY: The GROUP BY statement is used to group data by one or more columns. It is often used with aggregate functions such as SUM, COUNT, and AVG.
ORDER BY: The ORDER BY statement is used to sort data by one or more columns. It can sort in ascending or descending order.
HAVING: The HAVING statement is used to filter groups based on a condition. It is similar to the WHERE statement but is applied to groups instead of individual rows.
UNION: The UNION statement is used to combine the results of two or more SELECT statements into a single result set.
DISTINCT: The DISTINCT statement is used to retrieve unique values from a column in a table.
COUNT: The COUNT function is used to count the number of rows or non-null values in a column.
SUM: The SUM function is used to calculate the sum of values in a column.
AVG: The AVG function is used to calculate the average value in a column.
MAX: The MAX function is used to retrieve the maximum value in a column.
MIN: The MIN function is used to retrieve the minimum value in a column.
top of page
Search
bottom of page
Comments