Hitachi Advanced Database SQL Reference
Contents
Glossary
Index
Previous
155 / 355
Next
Cover
7. Constituent Elements
This chapter describes the elements that make up SQL.
7.1 Query expression
7.2 Query specification
7.3 Subqueries
7.4 Table expression
7.5 FROM clause
7.6 WHERE clause
7.7 GROUP BY clause
7.8 HAVING clause
7.9 LIMIT clause
7.10 DEFAULT clause
7.11 Table reference
7.12 Joined tables
7.13 Join method specification
7.14 Index specification
7.15 System-defined functions
7.16 Multiset value expression
7.17 Table value constructors
7.18 Search conditions
7.19 Predicates
7.20 Value expression
7.21 Value specification
7.22 Set functions
7.23 Window functions
7.24 Sort specification list
7.25 Arithmetic operations
7.26 Concatenation operations
7.27 Datetime operations
7.28 Labeled duration
7.29 CASE expression
7.30 Internal derived tables
To Page Top