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

Contents
HP NonStop SQL/MX Quick Start—523724-002
ii
3. Stating Conditions for Selecting Data
Selecting Distinct Rows 2-5
Displaying Information in an Ordered Sequence 2-6
3. Stating Conditions for Selecting Data
Using Predicates to Select Data 3-1
Using the LIKE Predicate 3-2
Specifying More Than One Condition 3-3
Using AND or OR 3-3
Specifying What Not to Select 3-4
4. Displaying Information About Groups of Rows
Selecting Values by Using Aggregate Functions 4-1
Grouping and Ordering Rows 4-2
Counting Rows 4-4
Computing Averages for Groups 4-5
5. Selecting Data From More Than One Table
Joining Tables 5-1
Qualifying Ambiguous Column Names 5-2
Using Correlation Names 5-3
6. Changing Information in a Table
Inserting a Row Into a Table 6-1
Updating an Existing Row 6-2
Deleting Rows From a Table 6-3
7. Using the Same SELECT Statement Repeatedly
Preparing to Execute a Statement Repeatedly 7-1
Providing the Parameter Values
7-2
8. Protecting Database Integrity
Starting a Transaction 8-1
Ending a Transaction 8-2