SQL/MX Quick Start (H06.04+, J06.03+)

HP NonStop SQL/MX Quick Start—540438-001
Index-1
Index
A
Aggregate functions 4-1
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
catalog 9-1
table 9-2
view 9-3
D
DELETE statement 6-3
Deleting rows 6-3
DEPT table 1-3
DESC keyword 2-7
Displaying
calculated values 2-3
descriptions of columns 2-4
information in an ordered sequence 2-6
selected rows 2-2
DISTINCT keyword 2-5
E
EMPLOYEE table 1-3
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
Installing the sample database 1-6
INVOKE command 2-4
J
Joining tables 5-1