1. SELECT Statement:
- Function: Retrieving data from one or more tables.
- Example:
SELECT column1, column2 FROM table WHERE condition;2. COUNT Function:
- Function: Counts the number of rows that meet a specified condition.
- Example:
SELECT COUNT(column) FROM table WHERE condition;3. SUM Function:
- Function: Calculates the sum of values in a numeric column.
- Example:
SELECT SUM(column) FROM table WHERE condition;4. AVG Function:
- Function: Computes the average value of a numeric column.
- Example:
SELECT AVG(column) FROM table WHERE condition;5. GROUP BY Clause:
- Function: Groups rows that have the same values in specified columns into summary rows.
- Example:
SELECT column, AVG(numeric_column) FROM table GROUP BY column;These functions are fundamental in SQL and are frequently used for various data manipulation tasks, including data retrieval, aggregation, and analysis.