SQL Functions - Documentation

Introduction

SQL provides a powerful and flexible way to interact with databases. Functions are fundamental building blocks for structured queries, allowing you to encapsulate reusable code blocks.

Basic Functions

Several basic functions exist:

SELECT: Retrieve data from a table.
WHERE: Filter data based on conditions.
DATE: Work with dates and times.
DATE: Work with dates and times.
SUBSTRING: Extract a portion of a string.
LEFTSUBSTRING: Extract a portion of a string from the left.
RIGHTSUBSTRING: Extract a portion of a string from the right.
: Return a value.

: Return a value (similar to return).

SELECT

Retrieve specific columns from a table.

WHERE

Filter data based on a condition.

DATE

Work with dates and times.

SUBSTRING

Extract a portion of a string.

LEFTSUBSTRING

Extract a portion of a string from the left.

RIGHTSUBSTRING

Extract a portion of a string from the right.

Return a value.

Return a value (similar to return).

Copyright 2023. All rights reserved.