SQL Functions

AVG()

Calculates the average value of a set of values.

Learn More →

COUNT()

Counts the number of rows or non-null values in a column.

Learn More →

MAX()

Finds the maximum value in a column.

Learn More →

MIN()

Finds the minimum value in a column.

Learn More →

SUM()

Calculates the sum of values in a column.

Learn More →

CONCAT()

Concatenates two or more strings.

Learn More →

LENGTH()

Returns the length of a string.

Learn More →

SUBSTRING()

Extracts a part of a string.

Learn More →

UPPER()

Converts a string to uppercase.

Learn More →

LOWER()

Converts a string to lowercase.

Learn More →

GETDATE()

Returns the current system date and time.

Learn More →

DATEADD()

Adds a specified time interval to a date.

Learn More →

DATEDIFF()

Returns the difference between two dates.

Learn More →

FORMAT()

Formats a date or number value.

Learn More →

ABS()

Returns the absolute value of a number.

Learn More →

ROUND()

Rounds a number to a specified precision.

Learn More →

SQRT()

Returns the square root of a number.

Learn More →

ISNULL()

Replaces NULL values with a specified replacement value.

Learn More →

COALESCE()

Returns the first non-NULL expression in a list.

Learn More →

NEWID()

Generates a unique identifier (GUID).

Learn More →

Explore More

Delve deeper into the various categories of SQL functions available to enhance your data manipulation and querying capabilities.