ODBC and JDBC Guide

|
Contents 5
Chapter 7
Supported standards
Support for Unicode characters 35
SQL statements 35
SELECT statement 35
SQL clauses 36
FROM clause 37
WHERE clause 37
GROUP BY clause 38
HAVING clause 38
UNION operator 38
ORDER BY clause 39
FOR UPDATE clause 39
DELETE statement 42
INSERT statement 42
UPDATE statement 43
CREATE TABLE statement 44
ALTER TABLE statement 44
CREATE INDEX statement 45
DROP INDEX statement 45
SQL aggregate functions 46
SQL expressions 46
Field names 47
Constants 47
Exponential/scientific notation 48
Numeric operators 48
Character operators 48
Date operators 48
Relational operators 49
Logical operators 50
Functions 50
Functions that return character strings 51
Functions that return numbers 53
Functions that return dates 54
Operator precedence 54
ODBC Catalog functions 55
JDBC Meta Data functions 55
Reserved SQL keywords 55