MySQL CONCAT() Function
Learn how to use the MySQL CONCAT function for text and string manipulation with syntax, examples, and related SQL dialect notes.
CONCAT(value1, value2, ...)Reference Library
SQL Function Explorer
Search 259 SQL function pages across MySQL, PostgreSQL, SQL Server, and Oracle. Each page includes syntax, examples, and practical usage notes aligned with this site's tools.
Find Functions Fast
Showing 259 of 259 functions.
MySQL CONCAT_WS() Function
Learn how to use the MySQL CONCAT_WS function for text and string manipulation with syntax, examples, and related SQL dialect notes.
CONCAT_WS(value1, value2, ...)MySQL SUBSTRING() Function
Learn how to use the MySQL SUBSTRING function for text and string manipulation with syntax, examples, and related SQL dialect notes.
SUBSTRING(text, start, length)MySQL LEFT() Function
Learn how to use the MySQL LEFT function for text and string manipulation with syntax, examples, and related SQL dialect notes.
LEFT(text, number_of_characters)MySQL RIGHT() Function
Learn how to use the MySQL RIGHT function for text and string manipulation with syntax, examples, and related SQL dialect notes.
RIGHT(text, number_of_characters)MySQL REPLACE() Function
Learn how to use the MySQL REPLACE function for text and string manipulation with syntax, examples, and related SQL dialect notes.
REPLACE(text, search, replacement)MySQL TRIM() Function
Learn how to use the MySQL TRIM function for text and string manipulation with syntax, examples, and related SQL dialect notes.
TRIM(text)MySQL LTRIM() Function
Learn how to use the MySQL LTRIM function for text and string manipulation with syntax, examples, and related SQL dialect notes.
LTRIM(text)MySQL RTRIM() Function
Learn how to use the MySQL RTRIM function for text and string manipulation with syntax, examples, and related SQL dialect notes.
RTRIM(text)MySQL UPPER() Function
Learn how to use the MySQL UPPER function for text and string manipulation with syntax, examples, and related SQL dialect notes.
UPPER(text)MySQL LOWER() Function
Learn how to use the MySQL LOWER function for text and string manipulation with syntax, examples, and related SQL dialect notes.
LOWER(text)MySQL LENGTH() Function
Learn how to use the MySQL LENGTH function for text and string manipulation with syntax, examples, and related SQL dialect notes.
LENGTH(text)MySQL CHAR_LENGTH() Function
Learn how to use the MySQL CHAR_LENGTH function for text and string manipulation with syntax, examples, and related SQL dialect notes.
CHAR_LENGTH(text)MySQL LOCATE() Function
Learn how to use the MySQL LOCATE function for text and string manipulation with syntax, examples, and related SQL dialect notes.
LOCATE(search_text, text)MySQL INSTR() Function
Learn how to use the MySQL INSTR function for text and string manipulation with syntax, examples, and related SQL dialect notes.
INSTR(search_text, text)MySQL LPAD() Function
Learn how to use the MySQL LPAD function for text and string manipulation with syntax, examples, and related SQL dialect notes.
LPAD(text)MySQL RPAD() Function
Learn how to use the MySQL RPAD function for text and string manipulation with syntax, examples, and related SQL dialect notes.
RPAD(text)MySQL REVERSE() Function
Learn how to use the MySQL REVERSE function for text and string manipulation with syntax, examples, and related SQL dialect notes.
REVERSE(text)MySQL REPEAT() Function
Learn how to use the MySQL REPEAT function for text and string manipulation with syntax, examples, and related SQL dialect notes.
REPEAT(text)MySQL REGEXP_REPLACE() Function
Learn how to use the MySQL REGEXP_REPLACE function for text and string manipulation with syntax, examples, and related SQL dialect notes.
REGEXP_REPLACE(text, search, replacement)MySQL NOW() Function
Learn how to use the MySQL NOW date function with practical examples and cross-dialect alternatives.
NOW()MySQL CURDATE() Function
Learn how to use the MySQL CURDATE date function with practical examples and cross-dialect alternatives.
CURDATE()MySQL CURRENT_DATE() Function
Learn how to use the MySQL CURRENT_DATE date function with practical examples and cross-dialect alternatives.
CURRENT_DATE()MySQL CURRENT_TIMESTAMP() Function
Learn how to use the MySQL CURRENT_TIMESTAMP date function with practical examples and cross-dialect alternatives.
CURRENT_TIMESTAMP()MySQL DATE_ADD() Function
Learn how to use the MySQL DATE_ADD date function with practical examples and cross-dialect alternatives.
DATE_ADD(date, INTERVAL value unit)MySQL DATE_SUB() Function
Learn how to use the MySQL DATE_SUB date function with practical examples and cross-dialect alternatives.
DATE_SUB(date, INTERVAL value unit)MySQL DATEDIFF() Function
Learn how to use the MySQL DATEDIFF date function with practical examples and cross-dialect alternatives.
DATEDIFF(date1, date2)MySQL DATE_FORMAT() Function
Learn how to use the MySQL DATE_FORMAT date function with practical examples and cross-dialect alternatives.
DATE_FORMAT(date, format)MySQL YEAR() Function
Learn how to use the MySQL YEAR date function with practical examples and cross-dialect alternatives.
YEAR()MySQL MONTH() Function
Learn how to use the MySQL MONTH date function with practical examples and cross-dialect alternatives.
MONTH()MySQL DAY() Function
Learn how to use the MySQL DAY date function with practical examples and cross-dialect alternatives.
DAY()MySQL DAYNAME() Function
Learn how to use the MySQL DAYNAME date function with practical examples and cross-dialect alternatives.
DAYNAME()MySQL MONTHNAME() Function
Learn how to use the MySQL MONTHNAME date function with practical examples and cross-dialect alternatives.
MONTHNAME()MySQL LAST_DAY() Function
Learn how to use the MySQL LAST_DAY date function with practical examples and cross-dialect alternatives.
LAST_DAY()MySQL STR_TO_DATE() Function
Learn how to use the MySQL STR_TO_DATE date function with practical examples and cross-dialect alternatives.
STR_TO_DATE()MySQL TIMESTAMPDIFF() Function
Learn how to use the MySQL TIMESTAMPDIFF date function with practical examples and cross-dialect alternatives.
TIMESTAMPDIFF(date1, date2)MySQL IFNULL() Function
Learn how to use the MySQL IFNULL function to handle NULL values and default replacements.
IFNULL(value, replacement)MySQL COALESCE() Function
Learn how to use the MySQL COALESCE function to handle NULL values and default replacements.
COALESCE(value1, value2, ...)MySQL NULLIF() Function
Learn how to use the MySQL NULLIF function to handle NULL values and default replacements.
NULLIF(value1, value2)MySQL COUNT() Function
Learn how to use the MySQL COUNT aggregate function for summary queries and reports.
COUNT(*) or COUNT(column)MySQL SUM() Function
Learn how to use the MySQL SUM aggregate function for summary queries and reports.
SUM(expression)MySQL AVG() Function
Learn how to use the MySQL AVG aggregate function for summary queries and reports.
AVG(expression)MySQL MIN() Function
Learn how to use the MySQL MIN aggregate function for summary queries and reports.
MIN(expression)MySQL MAX() Function
Learn how to use the MySQL MAX aggregate function for summary queries and reports.
MAX(expression)MySQL GROUP_CONCAT() Function
Learn how to use the MySQL GROUP_CONCAT aggregate function for summary queries and reports.
GROUP_CONCAT(expression, delimiter)MySQL BIT_AND() Function
Learn how to use the MySQL BIT_AND aggregate function for summary queries and reports.
BIT_AND(expression)MySQL BIT_OR() Function
Learn how to use the MySQL BIT_OR aggregate function for summary queries and reports.
BIT_OR(expression)MySQL STDDEV() Function
Learn how to use the MySQL STDDEV aggregate function for summary queries and reports.
STDDEV(expression)MySQL VARIANCE() Function
Learn how to use the MySQL VARIANCE aggregate function for summary queries and reports.
VARIANCE(expression)MySQL ROUND() Function
Learn how to use the MySQL ROUND numeric function for calculations in SQL.
ROUND(number, decimal_places)MySQL CEIL() Function
Learn how to use the MySQL CEIL numeric function for calculations in SQL.
CEIL(number)MySQL FLOOR() Function
Learn how to use the MySQL FLOOR numeric function for calculations in SQL.
FLOOR(number)MySQL ABS() Function
Learn how to use the MySQL ABS numeric function for calculations in SQL.
ABS(number)MySQL MOD() Function
Learn how to use the MySQL MOD numeric function for calculations in SQL.
MOD(number, divisor)MySQL POWER() Function
Learn how to use the MySQL POWER numeric function for calculations in SQL.
POWER(number, exponent)MySQL SQRT() Function
Learn how to use the MySQL SQRT numeric function for calculations in SQL.
SQRT(number)MySQL RAND() Function
Learn how to use the MySQL RAND numeric function for calculations in SQL.
RAND(number)MySQL GREATEST() Function
Learn how to use the MySQL GREATEST numeric function for calculations in SQL.
GREATEST(number)MySQL LEAST() Function
Learn how to use the MySQL LEAST numeric function for calculations in SQL.
LEAST(number)MySQL JSON_EXTRACT() Function
Learn how to use the MySQL JSON_EXTRACT JSON function to read or modify JSON values in SQL.
JSON_EXTRACT(json_value, path)MySQL JSON_ARRAY() Function
Learn how to use the MySQL JSON_ARRAY JSON function to read or modify JSON values in SQL.
JSON_ARRAY(json_value, path)MySQL JSON_OBJECT() Function
Learn how to use the MySQL JSON_OBJECT JSON function to read or modify JSON values in SQL.
JSON_OBJECT(json_value, path)MySQL JSON_SET() Function
Learn how to use the MySQL JSON_SET JSON function to read or modify JSON values in SQL.
JSON_SET(json_value, path)MySQL JSON_REMOVE() Function
Learn how to use the MySQL JSON_REMOVE JSON function to read or modify JSON values in SQL.
JSON_REMOVE(json_value, path)MySQL JSON_CONTAINS() Function
Learn how to use the MySQL JSON_CONTAINS JSON function to read or modify JSON values in SQL.
JSON_CONTAINS(json_value, path)MySQL JSON_KEYS() Function
Learn how to use the MySQL JSON_KEYS JSON function to read or modify JSON values in SQL.
JSON_KEYS(json_value, path)MySQL JSON_LENGTH() Function
Learn how to use the MySQL JSON_LENGTH JSON function to read or modify JSON values in SQL.
JSON_LENGTH(json_value, path)MySQL ROW_NUMBER() Function
Learn how to use the MySQL ROW_NUMBER window function for ranking, offsets, and analytical queries.
ROW_NUMBER() OVER (ORDER BY column)MySQL RANK() Function
Learn how to use the MySQL RANK window function for ranking, offsets, and analytical queries.
RANK() OVER (ORDER BY column)MySQL DENSE_RANK() Function
Learn how to use the MySQL DENSE_RANK window function for ranking, offsets, and analytical queries.
DENSE_RANK() OVER (ORDER BY column)MySQL LAG() Function
Learn how to use the MySQL LAG window function for ranking, offsets, and analytical queries.
LAG(column, offset) OVER (ORDER BY column)MySQL LEAD() Function
Learn how to use the MySQL LEAD window function for ranking, offsets, and analytical queries.
LEAD(column, offset) OVER (ORDER BY column)MySQL FIRST_VALUE() Function
Learn how to use the MySQL FIRST_VALUE window function for ranking, offsets, and analytical queries.
FIRST_VALUE() OVER (ORDER BY column)MySQL LAST_VALUE() Function
Learn how to use the MySQL LAST_VALUE window function for ranking, offsets, and analytical queries.
LAST_VALUE() OVER (ORDER BY column)MySQL NTILE() Function
Learn how to use the MySQL NTILE window function for ranking, offsets, and analytical queries.
NTILE() OVER (ORDER BY column)PostgreSQL CONCAT() Function
Learn how to use the PostgreSQL CONCAT function for text and string manipulation with syntax, examples, and related SQL dialect notes.
CONCAT(value1, value2, ...)PostgreSQL STRING_AGG() Function
Learn how to use the PostgreSQL STRING_AGG function for text and string manipulation with syntax, examples, and related SQL dialect notes.
STRING_AGG(expression, delimiter)PostgreSQL SPLIT_PART() Function
Learn how to use the PostgreSQL SPLIT_PART function for text and string manipulation with syntax, examples, and related SQL dialect notes.
SPLIT_PART(text)PostgreSQL SUBSTRING() Function
Learn how to use the PostgreSQL SUBSTRING function for text and string manipulation with syntax, examples, and related SQL dialect notes.
SUBSTRING(text, start, length)PostgreSQL POSITION() Function
Learn how to use the PostgreSQL POSITION function for text and string manipulation with syntax, examples, and related SQL dialect notes.
POSITION(search_text, text)PostgreSQL REPLACE() Function
Learn how to use the PostgreSQL REPLACE function for text and string manipulation with syntax, examples, and related SQL dialect notes.
REPLACE(text, search, replacement)PostgreSQL TRIM() Function
Learn how to use the PostgreSQL TRIM function for text and string manipulation with syntax, examples, and related SQL dialect notes.
TRIM(text)PostgreSQL LTRIM() Function
Learn how to use the PostgreSQL LTRIM function for text and string manipulation with syntax, examples, and related SQL dialect notes.
LTRIM(text)PostgreSQL RTRIM() Function
Learn how to use the PostgreSQL RTRIM function for text and string manipulation with syntax, examples, and related SQL dialect notes.
RTRIM(text)PostgreSQL UPPER() Function
Learn how to use the PostgreSQL UPPER function for text and string manipulation with syntax, examples, and related SQL dialect notes.
UPPER(text)PostgreSQL LOWER() Function
Learn how to use the PostgreSQL LOWER function for text and string manipulation with syntax, examples, and related SQL dialect notes.
LOWER(text)PostgreSQL LENGTH() Function
Learn how to use the PostgreSQL LENGTH function for text and string manipulation with syntax, examples, and related SQL dialect notes.
LENGTH(text)PostgreSQL LEFT() Function
Learn how to use the PostgreSQL LEFT function for text and string manipulation with syntax, examples, and related SQL dialect notes.
LEFT(text, number_of_characters)PostgreSQL RIGHT() Function
Learn how to use the PostgreSQL RIGHT function for text and string manipulation with syntax, examples, and related SQL dialect notes.
RIGHT(text, number_of_characters)PostgreSQL REGEXP_REPLACE() Function
Learn how to use the PostgreSQL REGEXP_REPLACE function for text and string manipulation with syntax, examples, and related SQL dialect notes.
REGEXP_REPLACE(text, search, replacement)PostgreSQL TO_CHAR() Function
Learn how to use the PostgreSQL TO_CHAR function for text and string manipulation with syntax, examples, and related SQL dialect notes.
TO_CHAR(text)PostgreSQL NOW() Function
Learn how to use the PostgreSQL NOW date function with practical examples and cross-dialect alternatives.
NOW()PostgreSQL CURRENT_DATE() Function
Learn how to use the PostgreSQL CURRENT_DATE date function with practical examples and cross-dialect alternatives.
CURRENT_DATE()PostgreSQL CURRENT_TIMESTAMP() Function
Learn how to use the PostgreSQL CURRENT_TIMESTAMP date function with practical examples and cross-dialect alternatives.
CURRENT_TIMESTAMP()PostgreSQL DATE_TRUNC() Function
Learn how to use the PostgreSQL DATE_TRUNC date function with practical examples and cross-dialect alternatives.
DATE_TRUNC(part, date)PostgreSQL EXTRACT() Function
Learn how to use the PostgreSQL EXTRACT date function with practical examples and cross-dialect alternatives.
EXTRACT(part FROM date)PostgreSQL AGE() Function
Learn how to use the PostgreSQL AGE date function with practical examples and cross-dialect alternatives.
AGE()PostgreSQL TO_DATE() Function
Learn how to use the PostgreSQL TO_DATE date function with practical examples and cross-dialect alternatives.
TO_DATE()PostgreSQL TO_TIMESTAMP() Function
Learn how to use the PostgreSQL TO_TIMESTAMP date function with practical examples and cross-dialect alternatives.
TO_TIMESTAMP()PostgreSQL MAKE_DATE() Function
Learn how to use the PostgreSQL MAKE_DATE date function with practical examples and cross-dialect alternatives.
MAKE_DATE()PostgreSQL JUSTIFY_DAYS() Function
Learn how to use the PostgreSQL JUSTIFY_DAYS date function with practical examples and cross-dialect alternatives.
JUSTIFY_DAYS()PostgreSQL JUSTIFY_INTERVAL() Function
Learn how to use the PostgreSQL JUSTIFY_INTERVAL date function with practical examples and cross-dialect alternatives.
JUSTIFY_INTERVAL()PostgreSQL COALESCE() Function
Learn how to use the PostgreSQL COALESCE function to handle NULL values and default replacements.
COALESCE(value1, value2, ...)PostgreSQL NULLIF() Function
Learn how to use the PostgreSQL NULLIF function to handle NULL values and default replacements.
NULLIF(value1, value2)PostgreSQL COUNT() Function
Learn how to use the PostgreSQL COUNT aggregate function for summary queries and reports.
COUNT(*) or COUNT(column)PostgreSQL SUM() Function
Learn how to use the PostgreSQL SUM aggregate function for summary queries and reports.
SUM(expression)PostgreSQL AVG() Function
Learn how to use the PostgreSQL AVG aggregate function for summary queries and reports.
AVG(expression)PostgreSQL MIN() Function
Learn how to use the PostgreSQL MIN aggregate function for summary queries and reports.
MIN(expression)PostgreSQL MAX() Function
Learn how to use the PostgreSQL MAX aggregate function for summary queries and reports.
MAX(expression)PostgreSQL ARRAY_AGG() Function
Learn how to use the PostgreSQL ARRAY_AGG aggregate function for summary queries and reports.
ARRAY_AGG(expression)PostgreSQL BOOL_AND() Function
Learn how to use the PostgreSQL BOOL_AND aggregate function for summary queries and reports.
BOOL_AND(expression)PostgreSQL BOOL_OR() Function
Learn how to use the PostgreSQL BOOL_OR aggregate function for summary queries and reports.
BOOL_OR(expression)PostgreSQL JSON_AGG() Function
Learn how to use the PostgreSQL JSON_AGG aggregate function for summary queries and reports.
JSON_AGG(expression)PostgreSQL ROUND() Function
Learn how to use the PostgreSQL ROUND numeric function for calculations in SQL.
ROUND(number, decimal_places)PostgreSQL CEIL() Function
Learn how to use the PostgreSQL CEIL numeric function for calculations in SQL.
CEIL(number)PostgreSQL FLOOR() Function
Learn how to use the PostgreSQL FLOOR numeric function for calculations in SQL.
FLOOR(number)PostgreSQL ABS() Function
Learn how to use the PostgreSQL ABS numeric function for calculations in SQL.
ABS(number)PostgreSQL MOD() Function
Learn how to use the PostgreSQL MOD numeric function for calculations in SQL.
MOD(number, divisor)PostgreSQL POWER() Function
Learn how to use the PostgreSQL POWER numeric function for calculations in SQL.
POWER(number, exponent)PostgreSQL SQRT() Function
Learn how to use the PostgreSQL SQRT numeric function for calculations in SQL.
SQRT(number)PostgreSQL RANDOM() Function
Learn how to use the PostgreSQL RANDOM numeric function for calculations in SQL.
RANDOM(number)PostgreSQL GREATEST() Function
Learn how to use the PostgreSQL GREATEST numeric function for calculations in SQL.
GREATEST(number)PostgreSQL LEAST() Function
Learn how to use the PostgreSQL LEAST numeric function for calculations in SQL.
LEAST(number)PostgreSQL JSONB_EXTRACT_PATH() Function
Learn how to use the PostgreSQL JSONB_EXTRACT_PATH JSON function to read or modify JSON values in SQL.
JSONB_EXTRACT_PATH(json_value, path)PostgreSQL JSONB_SET() Function
Learn how to use the PostgreSQL JSONB_SET JSON function to read or modify JSON values in SQL.
JSONB_SET(json_value, path)PostgreSQL JSONB_ARRAY_LENGTH() Function
Learn how to use the PostgreSQL JSONB_ARRAY_LENGTH JSON function to read or modify JSON values in SQL.
JSONB_ARRAY_LENGTH(json_value, path)PostgreSQL JSON_BUILD_OBJECT() Function
Learn how to use the PostgreSQL JSON_BUILD_OBJECT JSON function to read or modify JSON values in SQL.
JSON_BUILD_OBJECT(json_value, path)PostgreSQL TO_JSON() Function
Learn how to use the PostgreSQL TO_JSON JSON function to read or modify JSON values in SQL.
TO_JSON(json_value, path)PostgreSQL ROW_TO_JSON() Function
Learn how to use the PostgreSQL ROW_TO_JSON JSON function to read or modify JSON values in SQL.
ROW_TO_JSON(json_value, path)PostgreSQL ROW_NUMBER() Function
Learn how to use the PostgreSQL ROW_NUMBER window function for ranking, offsets, and analytical queries.
ROW_NUMBER() OVER (ORDER BY column)PostgreSQL RANK() Function
Learn how to use the PostgreSQL RANK window function for ranking, offsets, and analytical queries.
RANK() OVER (ORDER BY column)PostgreSQL DENSE_RANK() Function
Learn how to use the PostgreSQL DENSE_RANK window function for ranking, offsets, and analytical queries.
DENSE_RANK() OVER (ORDER BY column)PostgreSQL LAG() Function
Learn how to use the PostgreSQL LAG window function for ranking, offsets, and analytical queries.
LAG(column, offset) OVER (ORDER BY column)PostgreSQL LEAD() Function
Learn how to use the PostgreSQL LEAD window function for ranking, offsets, and analytical queries.
LEAD(column, offset) OVER (ORDER BY column)PostgreSQL FIRST_VALUE() Function
Learn how to use the PostgreSQL FIRST_VALUE window function for ranking, offsets, and analytical queries.
FIRST_VALUE() OVER (ORDER BY column)PostgreSQL LAST_VALUE() Function
Learn how to use the PostgreSQL LAST_VALUE window function for ranking, offsets, and analytical queries.
LAST_VALUE() OVER (ORDER BY column)PostgreSQL NTILE() Function
Learn how to use the PostgreSQL NTILE window function for ranking, offsets, and analytical queries.
NTILE() OVER (ORDER BY column)PostgreSQL PERCENT_RANK() Function
Learn how to use the PostgreSQL PERCENT_RANK window function for ranking, offsets, and analytical queries.
PERCENT_RANK() OVER (ORDER BY column)SQL Server CONCAT() Function
Learn how to use the SQL Server CONCAT function for text and string manipulation with syntax, examples, and related SQL dialect notes.
CONCAT(value1, value2, ...)SQL Server STRING_AGG() Function
Learn how to use the SQL Server STRING_AGG function for text and string manipulation with syntax, examples, and related SQL dialect notes.
STRING_AGG(expression, delimiter)SQL Server SUBSTRING() Function
Learn how to use the SQL Server SUBSTRING function for text and string manipulation with syntax, examples, and related SQL dialect notes.
SUBSTRING(text, start, length)SQL Server LEFT() Function
Learn how to use the SQL Server LEFT function for text and string manipulation with syntax, examples, and related SQL dialect notes.
LEFT(text, number_of_characters)SQL Server RIGHT() Function
Learn how to use the SQL Server RIGHT function for text and string manipulation with syntax, examples, and related SQL dialect notes.
RIGHT(text, number_of_characters)SQL Server REPLACE() Function
Learn how to use the SQL Server REPLACE function for text and string manipulation with syntax, examples, and related SQL dialect notes.
REPLACE(text, search, replacement)SQL Server TRIM() Function
Learn how to use the SQL Server TRIM function for text and string manipulation with syntax, examples, and related SQL dialect notes.
TRIM(text)SQL Server LTRIM() Function
Learn how to use the SQL Server LTRIM function for text and string manipulation with syntax, examples, and related SQL dialect notes.
LTRIM(text)SQL Server RTRIM() Function
Learn how to use the SQL Server RTRIM function for text and string manipulation with syntax, examples, and related SQL dialect notes.
RTRIM(text)SQL Server UPPER() Function
Learn how to use the SQL Server UPPER function for text and string manipulation with syntax, examples, and related SQL dialect notes.
UPPER(text)SQL Server LOWER() Function
Learn how to use the SQL Server LOWER function for text and string manipulation with syntax, examples, and related SQL dialect notes.
LOWER(text)SQL Server LEN() Function
Learn how to use the SQL Server LEN function for text and string manipulation with syntax, examples, and related SQL dialect notes.
LEN(text)SQL Server CHARINDEX() Function
Learn how to use the SQL Server CHARINDEX function for text and string manipulation with syntax, examples, and related SQL dialect notes.
CHARINDEX(search_text, text)SQL Server PATINDEX() Function
Learn how to use the SQL Server PATINDEX function for text and string manipulation with syntax, examples, and related SQL dialect notes.
PATINDEX(text)SQL Server FORMAT() Function
Learn how to use the SQL Server FORMAT function for text and string manipulation with syntax, examples, and related SQL dialect notes.
FORMAT(text)SQL Server STUFF() Function
Learn how to use the SQL Server STUFF function for text and string manipulation with syntax, examples, and related SQL dialect notes.
STUFF(text)SQL Server STRING_SPLIT() Function
Learn how to use the SQL Server STRING_SPLIT function for text and string manipulation with syntax, examples, and related SQL dialect notes.
STRING_SPLIT(text)SQL Server TRANSLATE() Function
Learn how to use the SQL Server TRANSLATE function for text and string manipulation with syntax, examples, and related SQL dialect notes.
TRANSLATE(text)SQL Server GETDATE() Function
Learn how to use the SQL Server GETDATE date function with practical examples and cross-dialect alternatives.
GETDATE()SQL Server SYSDATETIME() Function
Learn how to use the SQL Server SYSDATETIME date function with practical examples and cross-dialect alternatives.
SYSDATETIME()SQL Server CURRENT_TIMESTAMP() Function
Learn how to use the SQL Server CURRENT_TIMESTAMP date function with practical examples and cross-dialect alternatives.
CURRENT_TIMESTAMP()SQL Server DATEADD() Function
Learn how to use the SQL Server DATEADD date function with practical examples and cross-dialect alternatives.
DATEADD(datepart, number, date)SQL Server DATEDIFF() Function
Learn how to use the SQL Server DATEDIFF date function with practical examples and cross-dialect alternatives.
DATEDIFF(date1, date2)SQL Server DATENAME() Function
Learn how to use the SQL Server DATENAME date function with practical examples and cross-dialect alternatives.
DATENAME(part FROM date)SQL Server DATEPART() Function
Learn how to use the SQL Server DATEPART date function with practical examples and cross-dialect alternatives.
DATEPART(part FROM date)SQL Server EOMONTH() Function
Learn how to use the SQL Server EOMONTH date function with practical examples and cross-dialect alternatives.
EOMONTH()SQL Server ISDATE() Function
Learn how to use the SQL Server ISDATE date function with practical examples and cross-dialect alternatives.
ISDATE()SQL Server ISNULL() Function
Learn how to use the SQL Server ISNULL function to handle NULL values and default replacements.
ISNULL(value, replacement)SQL Server COALESCE() Function
Learn how to use the SQL Server COALESCE function to handle NULL values and default replacements.
COALESCE(value1, value2, ...)SQL Server NULLIF() Function
Learn how to use the SQL Server NULLIF function to handle NULL values and default replacements.
NULLIF(value1, value2)SQL Server COUNT() Function
Learn how to use the SQL Server COUNT aggregate function for summary queries and reports.
COUNT(*) or COUNT(column)SQL Server SUM() Function
Learn how to use the SQL Server SUM aggregate function for summary queries and reports.
SUM(expression)SQL Server AVG() Function
Learn how to use the SQL Server AVG aggregate function for summary queries and reports.
AVG(expression)SQL Server MIN() Function
Learn how to use the SQL Server MIN aggregate function for summary queries and reports.
MIN(expression)SQL Server MAX() Function
Learn how to use the SQL Server MAX aggregate function for summary queries and reports.
MAX(expression)SQL Server CHECKSUM_AGG() Function
Learn how to use the SQL Server CHECKSUM_AGG aggregate function for summary queries and reports.
CHECKSUM_AGG(expression)SQL Server STDEV() Function
Learn how to use the SQL Server STDEV aggregate function for summary queries and reports.
STDEV(expression)SQL Server VAR() Function
Learn how to use the SQL Server VAR aggregate function for summary queries and reports.
VAR(expression)SQL Server ROUND() Function
Learn how to use the SQL Server ROUND numeric function for calculations in SQL.
ROUND(number, decimal_places)SQL Server CEILING() Function
Learn how to use the SQL Server CEILING numeric function for calculations in SQL.
CEILING(number)SQL Server FLOOR() Function
Learn how to use the SQL Server FLOOR numeric function for calculations in SQL.
FLOOR(number)SQL Server ABS() Function
Learn how to use the SQL Server ABS numeric function for calculations in SQL.
ABS(number)SQL Server POWER() Function
Learn how to use the SQL Server POWER numeric function for calculations in SQL.
POWER(number, exponent)SQL Server SQRT() Function
Learn how to use the SQL Server SQRT numeric function for calculations in SQL.
SQRT(number)SQL Server RAND() Function
Learn how to use the SQL Server RAND numeric function for calculations in SQL.
RAND(number)SQL Server SIGN() Function
Learn how to use the SQL Server SIGN numeric function for calculations in SQL.
SIGN(number)SQL Server JSON_VALUE() Function
Learn how to use the SQL Server JSON_VALUE JSON function to read or modify JSON values in SQL.
JSON_VALUE(json_value, path)SQL Server JSON_QUERY() Function
Learn how to use the SQL Server JSON_QUERY JSON function to read or modify JSON values in SQL.
JSON_QUERY(json_value, path)SQL Server JSON_MODIFY() Function
Learn how to use the SQL Server JSON_MODIFY JSON function to read or modify JSON values in SQL.
JSON_MODIFY(json_value, path)SQL Server ISJSON() Function
Learn how to use the SQL Server ISJSON JSON function to read or modify JSON values in SQL.
ISJSON(json_value, path)SQL Server OPENJSON() Function
Learn how to use the SQL Server OPENJSON JSON function to read or modify JSON values in SQL.
OPENJSON(json_value, path)SQL Server ROW_NUMBER() Function
Learn how to use the SQL Server ROW_NUMBER window function for ranking, offsets, and analytical queries.
ROW_NUMBER() OVER (ORDER BY column)SQL Server RANK() Function
Learn how to use the SQL Server RANK window function for ranking, offsets, and analytical queries.
RANK() OVER (ORDER BY column)SQL Server DENSE_RANK() Function
Learn how to use the SQL Server DENSE_RANK window function for ranking, offsets, and analytical queries.
DENSE_RANK() OVER (ORDER BY column)SQL Server LAG() Function
Learn how to use the SQL Server LAG window function for ranking, offsets, and analytical queries.
LAG(column, offset) OVER (ORDER BY column)SQL Server LEAD() Function
Learn how to use the SQL Server LEAD window function for ranking, offsets, and analytical queries.
LEAD(column, offset) OVER (ORDER BY column)SQL Server FIRST_VALUE() Function
Learn how to use the SQL Server FIRST_VALUE window function for ranking, offsets, and analytical queries.
FIRST_VALUE() OVER (ORDER BY column)SQL Server LAST_VALUE() Function
Learn how to use the SQL Server LAST_VALUE window function for ranking, offsets, and analytical queries.
LAST_VALUE() OVER (ORDER BY column)SQL Server NTILE() Function
Learn how to use the SQL Server NTILE window function for ranking, offsets, and analytical queries.
NTILE() OVER (ORDER BY column)SQL Server PERCENT_RANK() Function
Learn how to use the SQL Server PERCENT_RANK window function for ranking, offsets, and analytical queries.
PERCENT_RANK() OVER (ORDER BY column)Oracle CONCAT() Function
Learn how to use the Oracle CONCAT function for text and string manipulation with syntax, examples, and related SQL dialect notes.
CONCAT(value1, value2, ...)Oracle LISTAGG() Function
Learn how to use the Oracle LISTAGG function for text and string manipulation with syntax, examples, and related SQL dialect notes.
LISTAGG(expression, delimiter)Oracle SUBSTR() Function
Learn how to use the Oracle SUBSTR function for text and string manipulation with syntax, examples, and related SQL dialect notes.
SUBSTR(text, start, length)Oracle INSTR() Function
Learn how to use the Oracle INSTR function for text and string manipulation with syntax, examples, and related SQL dialect notes.
INSTR(search_text, text)Oracle REPLACE() Function
Learn how to use the Oracle REPLACE function for text and string manipulation with syntax, examples, and related SQL dialect notes.
REPLACE(text, search, replacement)Oracle TRIM() Function
Learn how to use the Oracle TRIM function for text and string manipulation with syntax, examples, and related SQL dialect notes.
TRIM(text)Oracle LTRIM() Function
Learn how to use the Oracle LTRIM function for text and string manipulation with syntax, examples, and related SQL dialect notes.
LTRIM(text)Oracle RTRIM() Function
Learn how to use the Oracle RTRIM function for text and string manipulation with syntax, examples, and related SQL dialect notes.
RTRIM(text)Oracle UPPER() Function
Learn how to use the Oracle UPPER function for text and string manipulation with syntax, examples, and related SQL dialect notes.
UPPER(text)Oracle LOWER() Function
Learn how to use the Oracle LOWER function for text and string manipulation with syntax, examples, and related SQL dialect notes.
LOWER(text)Oracle LENGTH() Function
Learn how to use the Oracle LENGTH function for text and string manipulation with syntax, examples, and related SQL dialect notes.
LENGTH(text)Oracle LPAD() Function
Learn how to use the Oracle LPAD function for text and string manipulation with syntax, examples, and related SQL dialect notes.
LPAD(text)Oracle RPAD() Function
Learn how to use the Oracle RPAD function for text and string manipulation with syntax, examples, and related SQL dialect notes.
RPAD(text)Oracle REGEXP_REPLACE() Function
Learn how to use the Oracle REGEXP_REPLACE function for text and string manipulation with syntax, examples, and related SQL dialect notes.
REGEXP_REPLACE(text, search, replacement)Oracle REGEXP_SUBSTR() Function
Learn how to use the Oracle REGEXP_SUBSTR function for text and string manipulation with syntax, examples, and related SQL dialect notes.
REGEXP_SUBSTR(text)Oracle SYSDATE() Function
Learn how to use the Oracle SYSDATE date function with practical examples and cross-dialect alternatives.
SYSDATE()Oracle SYSTIMESTAMP() Function
Learn how to use the Oracle SYSTIMESTAMP date function with practical examples and cross-dialect alternatives.
SYSTIMESTAMP()Oracle CURRENT_DATE() Function
Learn how to use the Oracle CURRENT_DATE date function with practical examples and cross-dialect alternatives.
CURRENT_DATE()Oracle ADD_MONTHS() Function
Learn how to use the Oracle ADD_MONTHS date function with practical examples and cross-dialect alternatives.
ADD_MONTHS()Oracle MONTHS_BETWEEN() Function
Learn how to use the Oracle MONTHS_BETWEEN date function with practical examples and cross-dialect alternatives.
MONTHS_BETWEEN(date1, date2)Oracle LAST_DAY() Function
Learn how to use the Oracle LAST_DAY date function with practical examples and cross-dialect alternatives.
LAST_DAY()Oracle NEXT_DAY() Function
Learn how to use the Oracle NEXT_DAY date function with practical examples and cross-dialect alternatives.
NEXT_DAY()Oracle EXTRACT() Function
Learn how to use the Oracle EXTRACT date function with practical examples and cross-dialect alternatives.
EXTRACT(part FROM date)Oracle TO_DATE() Function
Learn how to use the Oracle TO_DATE date function with practical examples and cross-dialect alternatives.
TO_DATE()Oracle TO_CHAR() Function
Learn how to use the Oracle TO_CHAR date function with practical examples and cross-dialect alternatives.
TO_CHAR(date, format)Oracle TRUNC() Function
Learn how to use the Oracle TRUNC date function with practical examples and cross-dialect alternatives.
TRUNC(part, date)Oracle NVL() Function
Learn how to use the Oracle NVL function to handle NULL values and default replacements.
NVL(value, replacement)Oracle NVL2() Function
Learn how to use the Oracle NVL2 function to handle NULL values and default replacements.
NVL2(value, replacement)Oracle COALESCE() Function
Learn how to use the Oracle COALESCE function to handle NULL values and default replacements.
COALESCE(value1, value2, ...)Oracle NULLIF() Function
Learn how to use the Oracle NULLIF function to handle NULL values and default replacements.
NULLIF(value1, value2)Oracle DECODE() Function
Learn how to use the Oracle DECODE function to handle NULL values and default replacements.
DECODE(value, replacement)Oracle COUNT() Function
Learn how to use the Oracle COUNT aggregate function for summary queries and reports.
COUNT(*) or COUNT(column)Oracle SUM() Function
Learn how to use the Oracle SUM aggregate function for summary queries and reports.
SUM(expression)Oracle AVG() Function
Learn how to use the Oracle AVG aggregate function for summary queries and reports.
AVG(expression)Oracle MIN() Function
Learn how to use the Oracle MIN aggregate function for summary queries and reports.
MIN(expression)Oracle MAX() Function
Learn how to use the Oracle MAX aggregate function for summary queries and reports.
MAX(expression)Oracle STDDEV() Function
Learn how to use the Oracle STDDEV aggregate function for summary queries and reports.
STDDEV(expression)Oracle VARIANCE() Function
Learn how to use the Oracle VARIANCE aggregate function for summary queries and reports.
VARIANCE(expression)Oracle ROUND() Function
Learn how to use the Oracle ROUND numeric function for calculations in SQL.
ROUND(number, decimal_places)Oracle CEIL() Function
Learn how to use the Oracle CEIL numeric function for calculations in SQL.
CEIL(number)Oracle FLOOR() Function
Learn how to use the Oracle FLOOR numeric function for calculations in SQL.
FLOOR(number)Oracle ABS() Function
Learn how to use the Oracle ABS numeric function for calculations in SQL.
ABS(number)Oracle MOD() Function
Learn how to use the Oracle MOD numeric function for calculations in SQL.
MOD(number, divisor)Oracle POWER() Function
Learn how to use the Oracle POWER numeric function for calculations in SQL.
POWER(number, exponent)Oracle SQRT() Function
Learn how to use the Oracle SQRT numeric function for calculations in SQL.
SQRT(number)Oracle GREATEST() Function
Learn how to use the Oracle GREATEST numeric function for calculations in SQL.
GREATEST(number)Oracle LEAST() Function
Learn how to use the Oracle LEAST numeric function for calculations in SQL.
LEAST(number)Oracle JSON_VALUE() Function
Learn how to use the Oracle JSON_VALUE JSON function to read or modify JSON values in SQL.
JSON_VALUE(json_value, path)Oracle JSON_QUERY() Function
Learn how to use the Oracle JSON_QUERY JSON function to read or modify JSON values in SQL.
JSON_QUERY(json_value, path)Oracle JSON_OBJECT() Function
Learn how to use the Oracle JSON_OBJECT JSON function to read or modify JSON values in SQL.
JSON_OBJECT(json_value, path)Oracle JSON_ARRAY() Function
Learn how to use the Oracle JSON_ARRAY JSON function to read or modify JSON values in SQL.
JSON_ARRAY(json_value, path)Oracle JSON_EXISTS() Function
Learn how to use the Oracle JSON_EXISTS JSON function to read or modify JSON values in SQL.
JSON_EXISTS(json_value, path)Oracle ROW_NUMBER() Function
Learn how to use the Oracle ROW_NUMBER window function for ranking, offsets, and analytical queries.
ROW_NUMBER() OVER (ORDER BY column)Oracle RANK() Function
Learn how to use the Oracle RANK window function for ranking, offsets, and analytical queries.
RANK() OVER (ORDER BY column)Oracle DENSE_RANK() Function
Learn how to use the Oracle DENSE_RANK window function for ranking, offsets, and analytical queries.
DENSE_RANK() OVER (ORDER BY column)Oracle LAG() Function
Learn how to use the Oracle LAG window function for ranking, offsets, and analytical queries.
LAG(column, offset) OVER (ORDER BY column)Oracle LEAD() Function
Learn how to use the Oracle LEAD window function for ranking, offsets, and analytical queries.
LEAD(column, offset) OVER (ORDER BY column)Oracle FIRST_VALUE() Function
Learn how to use the Oracle FIRST_VALUE window function for ranking, offsets, and analytical queries.
FIRST_VALUE() OVER (ORDER BY column)Oracle LAST_VALUE() Function
Learn how to use the Oracle LAST_VALUE window function for ranking, offsets, and analytical queries.
LAST_VALUE() OVER (ORDER BY column)Oracle NTILE() Function
Learn how to use the Oracle NTILE window function for ranking, offsets, and analytical queries.
NTILE() OVER (ORDER BY column)Oracle PERCENT_RANK() Function
Learn how to use the Oracle PERCENT_RANK window function for ranking, offsets, and analytical queries.
PERCENT_RANK() OVER (ORDER BY column)