Calculates the average value of a numeric column.
AVG(expression)
Concatenates two or more string values.
CONCAT(string1, string2, ...)
Returns the current date.
CURDATE()
Rounds a number to a specified number of decimal places.
ROUND(number, decimals)
Returns a value if a condition is true, otherwise returns another value.
IF(condition, value_if_true, value_if_false)
Counts the number of rows or non-NULL values in a column.
COUNT(expression)
Converts a string to uppercase.
UPPER(string)
Converts a string to lowercase.
LOWER(string)
Returns the current date and time.
NOW()
Returns the absolute value of a number.
ABS(number)
Calculates the sum of values in a numeric column.
SUM(expression)
Extracts a part of a string.
SUBSTRING(string, start, length)
Formats a date value into a different format.
DATE_FORMAT(date, format)
Returns the smallest integer value greater than or equal to a number.
CEIL(number)
Allows for conditional logic within SQL queries.
CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 ... ELSE result_else END