# Special Functions

- [Dynamic Columns Functions](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions.md): Learn about dynamic column functions in MariaDB Server. This section details SQL functions for manipulating and querying dynamic columns, enabling flexible schema design and data storage.
- [COLUMN\_ADD](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_add.md)
- [COLUMN\_CHECK](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_check.md)
- [COLUMN\_CREATE](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_create.md)
- [COLUMN\_DELETE](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_delete.md)
- [COLUMN\_EXISTS](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_exists.md)
- [COLUMN\_GET](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_get.md)
- [COLUMN\_JSON](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_json.md)
- [COLUMN\_LIST](/docs/server/reference/sql-functions/special-functions/dynamic-columns-functions/column_list.md)
- [Galera Functions](/docs/server/reference/sql-functions/special-functions/galera-functions.md): Explore Galera functions in MariaDB Server. This section details special SQL functions for monitoring and managing Galera Cluster, essential for high availability and distributed database operations.
- [WSREP\_LAST\_SEEN\_GTID](/docs/server/reference/sql-functions/special-functions/galera-functions/wsrep_last_seen_gtid.md)
- [WSREP\_LAST\_WRITTEN\_GTID](/docs/server/reference/sql-functions/special-functions/galera-functions/wsrep_last_written_gtid.md)
- [WSREP\_SYNC\_WAIT\_UPTO\_GTID](/docs/server/reference/sql-functions/special-functions/galera-functions/wsrep_sync_wait_upto_gtid.md)
- [Geographic Functions](/docs/server/reference/sql-functions/special-functions/geographic-functions.md)
- [JSON Functions](/docs/server/reference/sql-functions/special-functions/json-functions.md): Explore JSON functions in MariaDB Server. This section details SQL functions for creating, manipulating, and querying JSON data, enabling flexible and efficient handling of unstructured data.
- [Differences between JSON\_QUERY and JSON\_VALUE](/docs/server/reference/sql-functions/special-functions/json-functions/differences-between-json_query-and-json_value.md)
- [JSON\_ARRAY](/docs/server/reference/sql-functions/special-functions/json-functions/json_array.md)
- [JSON\_ARRAY\_APPEND](/docs/server/reference/sql-functions/special-functions/json-functions/json_array_append.md)
- [JSON\_ARRAY\_INSERT](/docs/server/reference/sql-functions/special-functions/json-functions/json_array_insert.md)
- [JSON\_ARRAY\_INTERSECT](/docs/server/reference/sql-functions/special-functions/json-functions/json_array_intersect.md)
- [JSON\_ARRAYAGG](/docs/server/reference/sql-functions/special-functions/json-functions/json_arrayagg.md)
- [JSON\_COMPACT](/docs/server/reference/sql-functions/special-functions/json-functions/json_compact.md)
- [JSON\_CONTAINS](/docs/server/reference/sql-functions/special-functions/json-functions/json_contains.md)
- [JSON\_CONTAINS\_PATH](/docs/server/reference/sql-functions/special-functions/json-functions/json_contains_path.md)
- [JSON\_DEPTH](/docs/server/reference/sql-functions/special-functions/json-functions/json_depth.md)
- [JSON\_DETAILED](/docs/server/reference/sql-functions/special-functions/json-functions/json_detailed.md)
- [JSON\_EQUALS](/docs/server/reference/sql-functions/special-functions/json-functions/json_equals.md)
- [JSON\_EXISTS](/docs/server/reference/sql-functions/special-functions/json-functions/json_exists.md)
- [JSON\_EXTRACT](/docs/server/reference/sql-functions/special-functions/json-functions/json_extract.md)
- [JSON\_INSERT](/docs/server/reference/sql-functions/special-functions/json-functions/json_insert.md)
- [JSON\_KEY\_VALUE](/docs/server/reference/sql-functions/special-functions/json-functions/json_key_value.md)
- [JSON\_KEYS](/docs/server/reference/sql-functions/special-functions/json-functions/json_keys.md)
- [JSON\_LENGTH](/docs/server/reference/sql-functions/special-functions/json-functions/json_length.md)
- [JSON\_LOOSE](/docs/server/reference/sql-functions/special-functions/json-functions/json_loose.md)
- [JSON\_MERGE](/docs/server/reference/sql-functions/special-functions/json-functions/json_merge.md)
- [JSON\_MERGE\_PATCH](/docs/server/reference/sql-functions/special-functions/json-functions/json_merge_patch.md)
- [JSON\_MERGE\_PRESERVE](/docs/server/reference/sql-functions/special-functions/json-functions/json_merge_preserve.md)
- [JSON\_NORMALIZE](/docs/server/reference/sql-functions/special-functions/json-functions/json_normalize.md)
- [JSON\_OBJECT](/docs/server/reference/sql-functions/special-functions/json-functions/json_object.md)
- [JSON\_OBJECT\_FILTER\_KEYS](/docs/server/reference/sql-functions/special-functions/json-functions/json_object_filter_keys.md)
- [JSON\_OBJECT\_TO\_ARRAY](/docs/server/reference/sql-functions/special-functions/json-functions/json_object_to_array.md)
- [JSON\_OBJECTAGG](/docs/server/reference/sql-functions/special-functions/json-functions/json_objectagg.md)
- [JSON\_OVERLAPS](/docs/server/reference/sql-functions/special-functions/json-functions/json_overlaps.md)
- [JSON\_PRETTY](/docs/server/reference/sql-functions/special-functions/json-functions/json_pretty.md)
- [JSON\_QUERY](/docs/server/reference/sql-functions/special-functions/json-functions/json_query.md)
- [JSON\_QUOTE](/docs/server/reference/sql-functions/special-functions/json-functions/json_quote.md)
- [JSON\_REMOVE](/docs/server/reference/sql-functions/special-functions/json-functions/json_remove.md)
- [JSON\_REPLACE](/docs/server/reference/sql-functions/special-functions/json-functions/json_replace.md)
- [JSON\_SCHEMA\_VALID](/docs/server/reference/sql-functions/special-functions/json-functions/json_schema_valid.md)
- [JSON\_SEARCH](/docs/server/reference/sql-functions/special-functions/json-functions/json_search.md)
- [JSON\_SET](/docs/server/reference/sql-functions/special-functions/json-functions/json_set.md)
- [JSON\_TABLE](/docs/server/reference/sql-functions/special-functions/json-functions/json_table.md)
- [JSON\_TYPE](/docs/server/reference/sql-functions/special-functions/json-functions/json_type.md)
- [JSON\_UNQUOTE](/docs/server/reference/sql-functions/special-functions/json-functions/json_unquote.md)
- [JSON\_VALID](/docs/server/reference/sql-functions/special-functions/json-functions/json_valid.md)
- [JSON\_VALUE](/docs/server/reference/sql-functions/special-functions/json-functions/json_value.md)
- [JSONPath Expressions](/docs/server/reference/sql-functions/special-functions/json-functions/jsonpath-expressions.md)
- [Window Functions](/docs/server/reference/sql-functions/special-functions/window-functions.md): Explore window functions in MariaDB Server. This section details SQL functions that perform calculations across a set of table rows related to the current row, enabling advanced analytical queries.
- [Window Functions Overview](/docs/server/reference/sql-functions/special-functions/window-functions/window-functions-overview.md)
- [Aggregate Functions as Window Functions](/docs/server/reference/sql-functions/special-functions/window-functions/aggregate-functions-as-window-functions.md)
- [ColumnStore Window Functions](/docs/server/reference/sql-functions/special-functions/window-functions/window-functions-columnstore-window-functions.md)
- [Window Frames](/docs/server/reference/sql-functions/special-functions/window-functions/window-frames.md)
- [CUME\_DIST](/docs/server/reference/sql-functions/special-functions/window-functions/cume_dist.md)
- [DENSE\_RANK](/docs/server/reference/sql-functions/special-functions/window-functions/dense_rank.md)
- [FIRST\_VALUE](/docs/server/reference/sql-functions/special-functions/window-functions/first_value.md)
- [LAG](/docs/server/reference/sql-functions/special-functions/window-functions/lag.md)
- [LEAD](/docs/server/reference/sql-functions/special-functions/window-functions/lead.md)
- [MEDIAN](/docs/server/reference/sql-functions/special-functions/window-functions/median.md)
- [NTH\_VALUE](/docs/server/reference/sql-functions/special-functions/window-functions/nth_value.md)
- [NTILE](/docs/server/reference/sql-functions/special-functions/window-functions/ntile.md)
- [PERCENT\_RANK](/docs/server/reference/sql-functions/special-functions/window-functions/percent_rank.md)
- [PERCENTILE\_CONT](/docs/server/reference/sql-functions/special-functions/window-functions/percentile_cont.md)
- [PERCENTILE\_DISC](/docs/server/reference/sql-functions/special-functions/window-functions/percentile_disc.md)
- [RANK](/docs/server/reference/sql-functions/special-functions/window-functions/rank.md)
- [ROW\_NUMBER](/docs/server/reference/sql-functions/special-functions/window-functions/row_number.md)
