SQL/MX Quick Start (G06.24+, H06.03+)

HP NonStop SQL/MX Quick Start—523724-002
Index-1
Index
A
Ambiguous table names
correlation name 5-2
table name 5-2
AND operator 3-3
Arithmetic operators 2-4
AS clause 2-4
Audited tables 8-2
AVG function 4-5
B
BEGIN WORK statement 8-1
BETWEEN predicate 3-1, 3-5
C
Calculated values 2-3
Character data 2-5
Column definitions 2-5
COMMIT WORK statement 8-1, 8-2
Comparison operator 3-1
Computing averages 4-5
Correlation names 5-3
COUNT DISTINCT function 4-4
COUNT function 4-4
Counting rows 4-4
COUNT(*) function 4-4
CREATE 9-1, 9-3
Creating a catalog 9-1
Creating a table 9-2
Creating a view 9-3
D
DELETE statement 6-3
Deleting rows 6-3
DEPT table 1-2
DESC keyword 2-7
DISTINCT keyword 2-5
E
EMPLOYEE table 1-2
EMPNUM 9-2
Ending a transaction 8-2
Enter key 2-3
EXECUTE statement 7-2
F
FROM clause 2-2
G
GROUP BY clause 4-2
Groups of rows 4-1
H
HAVING clause 4-5
I
IN predicate 3-1
INSERT statement
omitting column names 6-1
WHERE clause 6-2
INVOKE command 2-4
J
Joining tables 5-1
L
LIKE predicate 3-1, 3-2, 3-3
Logical operators
AND 3-3
NOT 3-4, 3-5
OR 3-3
sequence of evaluation 3-4