SQL





SQL :

<query> SELECT

<subquery> SELECT , - .

<value expression> <primary> | <primary> <operator> <primary> | <primary> <operator> <value expression>

<operator> : + - / *

<primary> <column name> | <literal> | <aggregate function> | <built-in constant> | <nonstandard function>

<literal> <string> | <mathematical expressio>

<built-in constant> USER | <implementation-defined constant>

<table name> <identifier>

<column spec> [<table name> | <alias>.]<column name>

<grouping column> <column spec> | <integer>

<ordering column> <column spec> | <integer>

<colconstraint> NOT NULL | UNIQUE | CHECK (<predicate>) | PRIMARY KEY | REFERENCES <table name>[(<column name>)]

<tabconstraint> UNIQUE (<column list>) | CHECK (<predicate>) | PRIMARY KEY (<column list>) | FOREIGN KEY (<column list>) | REFERENCES <table name>[(<column list>)]

<defvalue> = <value expression>

<data type> (. , ANSI, - .)

<size> <data type>(. .)

<cursor name> <identifier>

<index name> <identifier>

<synonym> <identifier>(**)

<owner> <Authorization ID>

<column list> <column spec> .,..

<value list> <value expression> .,..

<table reference> { <table name> [<alias>] } .,..