Updated on 2024-05-07 GMT+08:00

SQL Syntax

Table 1 SQL syntax

Format

Description

[ ]

The part enclosed in brackets ([]) is optional.

...

Preceding elements can appear repeatedly.

[ x | y | ... ]

One item is selected from two or more options or no item is selected.

{ x | y | ... }

One item is selected from two or more options.

[x | y | ... ] [ ... ]

Multiple parameters or no parameter can be selected. If multiple parameters are selected, separate them with spaces.

[ x | y | ... ] [ ,... ]

Multiple parameters or no parameter can be selected. If multiple parameters are selected, separate them with commas (,).

{ x | y | ... } [ ... ]

At least one parameter can be selected. If multiple parameters are selected, separate them with spaces.

{ x | y | ... } [ ,... ]

At least one parameter can be selected. If multiple parameters are selected, separate them with commas (,).