SQL Functions Index

Introduction

This page provides a comprehensive overview of the SQL functions available.

Core Functions

These are the most commonly used functions:

• SELECT - Retrieves data from the database.
• WHERE - Filters data based on conditions.
• GROUP BY - Groups data for aggregation.
• ORDER BY - Sorts data.
• LIMIT - Restricts the number of rows returned.
• COUNT - Counts rows.
• AVG - Calculates the average.
• MIN - Finds the minimum value.
• MAX - Finds the maximum value.

Advanced Functions

These functions offer more control and flexibility:

• IN - Checks if a value is within a set of values.
• BETWEEN - Checks if a value is within a range.
• LIKE - Matches a pattern in a string.
• SUBSTRING - Extracts a substring.
• LENGTH - Returns the length of a string.
• DATE - Works with dates and times.
• TIME - Works with times.

Interactive Functions

These functions are used for data manipulation and processing:

SUM - Calculates the sum of values.

AVG - Calculates the average of values.

COUNT - Counts the number of values.

DISTINCT - Returns unique values.

MAX - Finds the maximum value.