SQL/MX Report Writer Guide

Selecting Data for a Report
HP NonStop SQL/MX Report Writer Guide—527194-002
3-36
Row Value as Percent of All Row Values
+> FROM EMPLOYEE E, AVGTEMP A
+> WHERE E.DEPTNUM = A.DEPTNUM;
S> DETAIL DEPTNUM, EMPNUM, LAST_NAME,
+> SALARY AS F10.2,
+> COL 5 AS F10.2 HEADING 'PCT OF AVG';
S> LIST ALL;
DEPTNUM EMPNUM LAST_NAME SALARY PCT OF AVG
------- ------ ---------------- ---------- ----------
1000 23 HOWARD 137000.10 263.46
1000 202 CLARK 25000.75 48.08
1000 208 CRAMER 19000.00 36.54
. . . . .
. . . . .
. . . . .
9000 1 GREEN 175500.00 165.00
9000 337 CLARK 37000.00 34.82
--- 57 row(s) selected.
>>
You can drop or keep the interim table.