SQL Syntax

Chapter SQL Syntax

Table of Contents

Lexical Structure

 Identifiers and Key Words

 Constants

 Operators

 Special Characters

 Comments

 Operator Precedence

Value Expressions

 Column References

 Positional Parameters

 Subscripts

 Field Selection

 Operator Invocations

 Function Calls

 Aggregate Expressions

 Window Function Calls

 Type Casts

 Collation Expressions

 Scalar Subqueries

 Array Constructors

 Row Constructors

 Expression Evaluation Rules

Calling Functions

 Using Positional Notation

 Using Named Notation

 Using Mixed Notation

This chapter describes the syntax of SQL. It forms the foundation for understanding the following chapters which will go into detail about how SQL commands are applied to define and modify data.

We also advise users who are already familiar with SQL to read this chapter carefully because it contains several rules and concepts that are implemented inconsistently among SQL databases or that are specific to Tacnode.