Nov 15, 2025 · SQL functions are built-in operations that perform calculations, manipulate data, and return results in queries, making data handling simpler without writing complex code.

The SQL CASE Expression The CASE expression goes through conditions and returns a value when the first condition is met (like an if-then-else statement). So, once a condition is true, it will stop …

SQL has many mathematical functions that allow you to perform business and engineering calculations. This page covers the most important SQL date functions that allow you to effectively manipulate date …

Dec 5, 2025 · SQL functions are powerful tools that help streamline queries, perform operations, and manipulate data efficiently. They are essential for handling various tasks within SQL queries and …

Aug 25, 2021 · Your quick guide to SQL functions! Download the cheat sheet in PDF or PNG for syntax reference, examples, and tips.

Nov 18, 2025 · Transact-SQL reference for the STRING_SPLIT function. This table-valued function splits a string into substrings based on a character delimiter.

5 Functions How to use string functions, logical functions and mathematical functions. 6 Users How to create users, GRANT and DENY access, get at other peoples tables. How to find processes and kill …

Relational databases Before learning the SQL syntax, it's important to have a model for what a relational database actually is. A relational database represents a collection of related (two-dimensional) …

Expressions can be used at several points in SQL statements, such as in the ORDER BY or HAVING clauses of SELECT statements, in the WHERE clause of a SELECT, DELETE, or UPDATE …

Dec 11, 2025 · See how to easily extract text from a SQL string using the regex function REGEXP_SUBSTR to simplify text extraction.