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

Selecting Information From a Table
HP NonStop SQL/MX Quick Start—523724-002
2-7
Displaying Information in an Ordered Sequence
Example
Display customer numbers, order numbers, and delivery dates arranged in ascending
order by customer number. Select only orders of sales representatives identified by
numbers less than 300:
SELECT CUSTNUM, ORDERNUM, DELIV_DATE
FROM ORDERS
WHERE SALESREP < 300
ORDER BY CUSTNUM;
Some selected rows are:
Cust/Num ORDERNUM DELIV_DATE
------- ---------- ----------
30 200378 2003-08-22
111 200562 2003-10-12
131 300756 2003-12-20
156 700694 2004-01-14
... ... ...
7562 100171 2004-02-03
--- 12 row(s) selected.
Example
Display customer numbers, order numbers, and delivery dates arranged in ascending
order by customer number. Each customer’s orders are also arranged in ascending
order by the delivery date:
SELECT CUSTNUM, ORDERNUM, DELIV_DATE
FROM ORDERS
WHERE SALESREP < 300
ORDER BY CUSTNUM, DELIV_DATE;
Some selected rows are:
Cust/Num ORDERNUM DELIV_DATE
------- ---------- ----------
21 200320 2003-11-20
123 300380 2003-12-12
123 200490 2004-01-04
143 700510 2004-01-12
... ... ...
7777 100250 2004-02-02
--- 12 row(s) selected.
Tip
You can also arrange values in descending order by including the keyword DESC after
the name of one or more columns:
ORDER BY CUSTNUM DESC, DELIV_DATE DESC;