To select rows that satisfy a condition that is based on equality or inequality, put the condition under the appropriate column.
You can display a report with everyone who has 10 or more years of service.
When you run this query:
Q.STAFF | ID | NAME | DEPT | JOB | YEARS | SALARY | COMM |
--------+----+------+------+-----+---------------+--------+------|
| P. | P. | | | P. >=10 | | |
|
QMF produces this report:
ID NAME YEARS
------ ---------- ------
50 HANES 10
210 LU 10
260 JONES 12
290 QUILL 10
310 GRAHAM 13
If you do not specify an operator this way, the operator defaults to equality. You can write the following query to produce a report that contains all the managers.
When you run this query:
Q.STAFF | ID | NAME | DEPT | JOB | YEARS | SALARY | COMM |
--------+----+------+------+-----+-------+--------+------|
| P. | P. | | MGR | | | |
|
QMF produces this report:
ID NAME
------ ----------
10 SANDERS
30 MARENGHI
50 HANES
100 PLOTZ
140 FRAYE
160 MOLINARE
210 LU
240 DANIELS
260 JONES
270 LEA
290 QUILL
You can display a report that contains everyone later in the alphabet than SMITH.
When you run this query:
Q.STAFF | ID | NAME | DEPT | JOB | YEARS | SALARY | COMM |
--------+----+--------------+------+-----+-------+--------+------|
| P. | P. >SMITH AO.| | | | | |
|
QMF produces this report:
ID NAME ------ ---------- 190 SNEIDER 250 WHEELER 150 WILLIAMS 280 WILSON 130 YAMAGUCHI