AND

You can select rows based on multiple conditions connected by AND or OR. Two conditions connected by AND select only rows that satisfy both conditions. For example:

This query:

SELECT ID, NAME, YEARS, SALARY
FROM Q.STAFF
WHERE YEARS = 10 AND SALARY > 20000

Produces this report:

   ID  NAME       YEARS     SALARY
-----  ---------  -----  ---------
   50  HANES         10   20659.80
  210  LU            10   20010.00

Compare the results using AND with OR.