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

Index
HP NonStop SQL/MX Quick Start—523724-002
Index-2
M
M
MXCI
entering command 1-2
starting session 1-1
stopping session 1-2
N
NO DEFAULT 2-5
NOT NULL 2-5
NOT operator 3-1, 3-4
NULL predicate 3-1
Numeric data 2-5
O
ODETAIL table 1-2
OR operator 3-3
ORDER BY 1 4-2
ORDER BY clause 2-6
Ordered groups of rows 4-2
ORDERS table 1-2
P
Parameter
names 7-2
parameter
values 7-2
PARTS table 1-2
Predicates 3-1
PREPARE statement 7-1
Primary key 6-2
Q
Qualifying table names 5-2
R
ROLLBACK WORK statement 8-1, 8-2
Rows
counting 4-4
selected 2-2
S
Sample database
DEPT table 1-4
EMPLOYEE table 1-4
installing 1-5
INVENT subvolume 1-2
ODETAIL table 1-3
ORDERS table 1-3
PARTS table 1-3
PERSNL subvolume 1-2
SALES subvolume 1-2
SELECT statement
arithmetic operators 2-4
AS clause 2-4
calculated values 2-3
column names 2-2
DISTINCT rows 2-5
FROM clause 2-2
GROUP BY clause 4-2
HAVING clause 4-5
ORDER BY clause 2-6
predicates 3-1
retrieving data with 2-1
rows
in ascending order 2-7
in descending order 2-7
SELECT * 2-1, 2-2
WHERE clause 2-2
Selected columns 2-2
Selected rows 2-2
Selecting all data 2-1
Set functions
AVG 4-1
COUNT 4-1
COUNT(*) 4-1
MIN 4-1
SUM 4-1