Introduction
Deploy
Connect to SingleStore
Create a Database
Integrate with SingleStore
Load Data
Query Data
Manage Data
Developer Resources
User and Cluster Administration
Reference
Configuration Reference
SingleStore Operator Reference
SingleStore Tools Reference
SQL Reference
SQL Command Syntax
SQL Commands List
SQL Functions List
Comparison Operators and Functions
Database Object Case-Sensitivity
Data Types
Character Encoding
Operations that Take Either a Database or a Cluster Level Lock
User-Defined Variables
Restricted Keywords
Aggregate Functions
BSON Functions
Cluster Management Commands
Code Generation Functions
Conditional Functions
Data Definition Language DDL
Data Manipulation Language DML
Date and Time Functions
Distinct Count Estimation Functions
Full-Text Search Functions
Geospatial Functions
Identifier Generation Functions
Information Functions
JSON Functions
Numeric Functions
Operational Commands
Pipelines Commands
Procedural SQL Reference
Anonymous Code Blocks
Control Flow Statements
Exceptions and Exception Handling
MySQL Client Delimiters
Transactions in Stored Procedures
Extensions
CREATE AGGREGATE
CREATE [OR REPLACE] EXTERNAL FUNCTION
CREATE FUNCTION (UDF)
CREATE FUNCTION (TVF)
CREATE PROCEDURE
CREATE [OR REPLACE] TEMPORARY PROCEDURE …
DROP FUNCTION
DROP PROCEDURE
DROP AGGREGATE
SHOW AGGREGATES
SHOW CREATE FUNCTION
SHOW CREATE AGGREGATE
SHOW FUNCTIONS
SHOW PROCEDURES
%ROWTYPE and %TYPE
ARRAY
CALL
CREATE_ARRAY
COLLECT
ECHO
ECHO SELECT
EXECUTE IMMEDIATE
INSERT_ALL
RECORD
ROW
QUERY
SCALAR
TO_QUERY
Regular Expression Functions
Resource Pool Commands
Security Management Commands
SHOW Commands
String Functions
Time Series Functions
Trace Event Commands
Vector Functions
Window Functions
Troubleshooting Reference
System Databases
Information Schema Reference
Data API
Code Engine - Powered by Wasm
Security
Release Notes
Support
Glossary
See SHOW FUNCTIONS.
Last modified: May 6, 2021
