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 | +--------------------------------------------------------------------------------+