Contents - SQL expressions
WHERE clause....................................................................................................86
WHERE CURRENT OF clause...........................................................................87
TableExpression.................................................................................................. 93
NEXT VALUE FOR expression...........................................................................94
VALUES expression............................................................................................ 95
Expression precedence....................................................................................... 96
Boolean expressions........................................................................................... 97
Dynamic parameters........................................................................................... 99
LEFT OUTER JOIN operation...........................................................................103
RIGHT OUTER JOIN operation........................................................................ 104
CROSS JOIN operation.................................................................................... 105
NATURAL JOIN operation................................................................................ 106
ScalarSubquery................................................................................................. 108
TableSubquery...................................................................................................109
Aggregates (set functions)................................................................................ 111
ABS or ABSVAL function.................................................................................. 112
ACOS function...................................................................................................112
ASIN function.....................................................................................................113
ATAN function................................................................................................... 113
ATAN2 function................................................................................................. 113
AVG function..................................................................................................... 114
BIGINT function................................................................................................. 114
CASE expressions.............................................................................................115
CAST function................................................................................................... 115
CEIL or CEILING function................................................................................. 119
CHAR function...................................................................................................119
COALESCE function......................................................................................... 120
Concatenation operator..................................................................................... 122
COS function..................................................................................................... 122
COSH function...................................................................................................122
COT function..................................................................................................... 122
COUNT function................................................................................................ 123
COUNT(*) function............................................................................................ 123
CURRENT DATE function.................................................................................123
CURRENT_DATE function................................................................................ 124
CURRENT ISOLATION function....................................................................... 124
CURRENT_ROLE function................................................................................124
CURRENT SCHEMA function........................................................................... 124
CURRENT TIME function..................................................................................125
CURRENT_TIME function................................................................................. 125
CURRENT TIMESTAMP function..................................................................... 125
CURRENT_TIMESTAMP function.....................................................................125
CURRENT_USER function................................................................................126
DATE function................................................................................................... 126
DAY function......................................................................................................127
DEGREES function........................................................................................... 127
DOUBLE function.............................................................................................. 127