Many times you will not want to view every row in a table. To select specific rows to view, use the WHERE keyword, followed by a condition. If you do not use the WHERE keyword, all the rows in the table are displayed.
For example, to select only the rows for employees who work in Department 20, type:
SELECT DEPT, NAME, JOB, COMM FROM Q.STAFF WHERE DEPT = 20
QMF displays this report when you run the query:
DEPT NAME JOB COMM ------ --------- ----- ---------- 20 SANDERS MGR - 20 PERNAL SALES 612.45 20 JAMES CLERK 128.20 20 SNEIDER CLERK 126.50[ Previous Page | Next Page | Contents | Index ]