SQL Language Elements

Keywords

Keywords are words that have a special meaning in the SQL language. Every SQL statement contains one or more keywords. Although SQL is not case-sensitive with respect to keywords, they are generally shown in uppercase letters throughout this documentation for readability purposes.

For more details click Keywords

Literals

Literals are numbers or strings used in SQL as constants. Literals are included in the select-list, along with expressions and built-in functions and can also be constants. Lyftrondata provides support for number-type literals (integers, numerics, money), string literals, VARBINARY string literals, and date/time literals. The various string literal formats are discussed in this section.

For more details click Literals

Expressions

It is a combination of symbols and operators that the Lyftrondata Engine evaluates to obtain a single data value. Simple expressions can be a single constant, variable, column, or scalar function. Operators can be used to join two or more simple expressions into a complex expression.

For more details click on Expressions

Operators

Operators are logical, mathematical, and equality symbols used in SQL to evaluate, compare, or calculate values.

For more details click Operators

Identifiers

Identifiers (names) of objects such as schema, table, projection, column names, etc.

For more details click Identifiers

Predicates

Predicates are truth-tests. If the predicate test is true, it returns a value. Each predicate is evaluated per row so that when the predicate is part of an entire table SELECT statement, the statement can return multiple results.

For more details click Predicates